Insert with Select

[Bell1991]

I have the following query:

declare @numID int
set @numID = 66

Insert into tblA (numID, txtName, txtAddress) values (Select @numID as numID, txtName, txtAddress from tblB where numID = @numID)

Is this possible? I am getting an error message - so i suspect it isn't.. but any ideas on how to make it work?

Thanks

 

[gol4]

try dropping the values

you can use select or values not both

Insert into tblA (numID, txtName, txtAddress)Select @numID as numID, txtName, txtAddress from tblB where @numID=numID

 

[Bell1991]

Thanks - worked great!!