Insert multiple rows using single insert statement

Question

I am trying to insert into table variable using following query. but its throwing an error. Please help on inserting multiple selects using single insert statement.

      DECLARE @AddressRecordsToPurge TABLE  
    (  
      RowID INT NOT NULL PRIMARY KEY IDENTITY(1,1),  
        GUIDValue Nvarchar(max) ,  
     GuidColumn Nvarchar(max) ,  
      GuidTable Nvarchar(max)  
     )    

    Insert Into @AddressRecordsToPurge values ( (Select            
    EMPLOYMENTSEQUENCENUMBER FROM ACCOUNTANTSREFERENCE  WHERE  
    CustomerNumber =  @CustomerNumber AND Customerversionnumber =  
    @CustomerVersionNumber AND EMPLOYMENTSEQUENCENUMBER IS NOT 
     NULL), 'EMPLOYMENTSEQUENC ENUMBER', 'ACCOUNTANTSREFERENCE');

My select statement returns multiple values and I want to have it this way only. Please help!

cf_en · Accepted Answer · 2017-11-24 17:31:26Z

4

Your syntax is slightly off:

Insert Into @AddressRecordsToPurge (GuidValue, GuidColumn, GuidTable)
SELECT EMPLOYMENTSEQUENCENUMBER, 'EMPLOYMENTSEQUENCENUMBER', 'ACCOUNTANTSREFERENCE'
FROM ACCOUNTANTSREFERENCE
WHERE CustomerNumber =  @CustomerNumber
    AND Customerversionnumber = @CustomerVersionNumber
    AND EMPLOYMENTSEQUENCENUMBER IS NOT NULL;

answered Nov 24, 2017 at 17:31

cf_en

1,6611 gold badge10 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abhijit Over a year ago

You are legend brother. It worked as smooth as cheesecake..cheers

Collectives™ on Stack Overflow

Insert multiple rows using single insert statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related