Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
declare @x int set @x = 1287003 while @x < 1287009 BEGIN INSERT INTO spreadsheet8 ([dateordered], [orderid], [internalsku], [quantity], [deliveryservicecode], [companyname], [shipaddress1], [shipaddress2],[shipaddress3], [shipzip], [country],[contactname], [shipphone1]) SELECT o.dateordered,o.OrderID,p.internalsku,i.Quantity,12, RTRIM ( LTRIM( o.shipfirstname + ' ' + o.shiplastname ) ) ,o.shipaddress1,o.shipaddress2,o.shipcity, o.shipzip,o.shipcountry, RTRIM ( LTRIM( o.shipfirstname + ' ' + o.shiplastname ) ) ,shipphone1 from products p inner join orderitems i on p.productid = i.productid inner join orders o on o.orderid = i.orderid where i.orderid = @x SET @x = @x +1 END select * from spreadsheet8 order by orderid desc
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
25 Experts available now in Live!