Home > SQL > INSERT INTO Table by selecting similar table with selected columns

INSERT INTO Table by selecting similar table with selected columns

INSERT INTO Item (ItemID, ItemName, ItemDescription, Manufacturer, Authentication_Info, NDC, DEA_Schedule, PedigreeItem, SaleDescription, ItemCost, ItemPrice, AWP, CF_Size)

SELECT ItemID, ItemName, ItemDescription, Manufacturer, Authentication_Info, NDC, DEA_Schedule, PedigreeItem, SaleDescription, ItemCost, ItemPrice, AWP, CF_Size from ParagonDB.dbo.TblItem

WHERE CatID IN(1,2,3,4,5,6,7,8,9,10,11,12) AND SubCatID IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) AND SVPG IS NULL

Comments are closed.

TOP