SQL SERVER How do you insert multiple rows using Insert into select statement

Question

This is my query, the commented line is what i want to insert

insert into tbl_StockTransactions(ItemCode,TransactionDate,Narration,Docid,ReferenceNo,Qty,Price,UserId,BranchCode,StaffCode) select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' from tbl_PostingDetailsStock where PostingReference='A000275'
--select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' from tbl_PostingDetailsStock where PostingReference='A000276';

Vikrant · Accepted Answer · 2016-11-25 10:48:59Z

3

Try this code:

insert into tbl_StockTransactions(
    ItemCode, TransactionDate, Narration, Docid, ReferenceNo, Qty,
    Price, UserId, BranchCode, StaffCode
)

SELECT ItemCode, getDate(), Description, PostingDocid, 'New Ref', Qty, 
    Price, 'uid', 'bc', 'sc' 
FROM tbl_PostingDetailsStock 
WHERE PostingReference IN ('A000275','A000276')

edited Nov 25, 2016 at 10:48

Vikrant

5,05218 gold badges53 silver badges77 bronze badges

answered Nov 25, 2016 at 9:00

anakpanti

3294 silver badges18 bronze badges

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

2 Comments

Emmanuel Ogoma Over a year ago

Sorry for those who have answered, this what i wanted

Vikrant Over a year ago

@EmmanuelOgoma, if it meets your requirements, click on check mark below just upvote button [flag it as Accepted] of this Answer.. to help in future use

Krish · Accepted Answer · 2016-11-25 09:10:50Z

0

select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' 
into tbl_StockTransactions
from tbl_PostingDetailsStock 
where PostingReference='A000275'

answered Nov 25, 2016 at 9:10

Krish

398 bronze badges

Comments

Munavvar · Accepted Answer · 2016-11-25 11:35:31Z

0

 insert into tbl_StockTransactions(ItemCode,TransactionDate,Narration
 ,Docid,ReferenceNo,Qty,Price,UserId,BranchCode,StaffCode)
 select ItemCode,getDate(),Description,PostingDocid,'New Ref',Qty,Price,'uid','bc','sc' from tbl_PostingDetailsStock
 where PostingReference IN ('A000275','A000276')

edited Nov 25, 2016 at 11:35

Munavvar

8312 gold badges11 silver badges33 bronze badges

answered Nov 25, 2016 at 8:49

Mansoor

4,1921 gold badge19 silver badges27 bronze badges

Collectives™ on Stack Overflow

SQL SERVER How do you insert multiple rows using Insert into select statement

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related