We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
@price_id int ,@destination_id int ,@qty int AS DECLARE @counter int SET @counter = 0 WHILE @counter < @qty BEGIN SET @counter = @counter + 1 INSERT INTO COT_FWD_XFER (price_id, destination_id, qty) VALUES (@price_id, @destination_id, 1) END BEGIN DECLARE @counter2 int SET @counter2 = 0 WHILE @counter2 < @qty SET @counter2 = @counter2 + 1 UPDATE COT_PO_Items SET qtyTransfer = 1 FROM COT_PO_Items INNER JOIN COT_Items ON COT_PO_Items.cot_items_id = COT_Items.cot_items_id INNER JOIN COT_PO ON COT_PO_Items.cot_po_id = COT_PO.cot_po_id WHERE (COT_Items.price_id = @price_id) AND (COT_PO.destination_id = @destination_id) END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL Express connecting form remote error 26||7||64|
|Table create permissions on SQL Server 2005||9||45|
|My Query is not giving correct result. Please help||5||56|
|calculate running total||8||51|
Join the community of 500,000 technology professionals and ask your questions.