Display total qty sold of each item of each store

Thanks Saravana,

but my UPC range and SaleDate range may vary.

Inputting each UPC# one by one into #temp1 and as a stored procedure may not be efficient since my database has at least thousands of records.

You can use dynamic sql along with PIVOT for that

see

http://ift.tt/1cOmTxL

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c