I am trying to basically copy a record from one table into another, at the same time adding 3 extra columns that the original table does not possess. I have this in a stored procedure like this:

@REC int,
@ChangedIP varchar(15),
@ChangedBY varchar(30)

AS

    INSERT INTO table_LOG
    VALUES ((SELECT * FROM table WHERE record = @REC),GETDATE(),@ChangedIP,@ChangedBY)

I am getting this error:

Subqueries are not allowed in this context. Only scalar expressions are allowed.

How can I achieve this? This is a procedure that will get called right before the original record gets updated in my application so the purpose of this is sort of a "history" table to log the original record along with a few bits of info about the change...

Appreciate any help on this...

When you use the VALUES( ) version of INSERT INTO, you can only insert *ONE* record. *AND* you can only have ONE field between eahc set of commmas (or between the "ends" and a comma). So that subquery is returning (a) potentially many records [you know it doesn't, SQL Server doesn't] and (b) many fields.

Happily the solution to what you want to *DO*, not to your question, is easy:
A different "form" of the INSERT INTO works just fine.

Thanks man - appreciate it as always!