SQLServerCentral.com / SQL Server 2005 / T-SQL (SS2K5) / Pivot Help--I need to Pivot really to just make the rows the column / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 12:01:51 GMT20RE: Pivot Help--I need to Pivot really to just make the rows the columnhttp://www.sqlservercentral.com/Forums/Topic1493263-338-1.aspxTake a look at the Cross Tab and Pivot links in my signature. I think they'll give you what you need.Wed, 11 Sep 2013 07:33:20 GMT Jack CorbettRE: Pivot Help--I need to Pivot really to just make the rows the columnhttp://www.sqlservercentral.com/Forums/Topic1493263-338-1.aspxYou're not giving enough information.We would be happy to help but we need you to be more explicit on what you need.Please post the DDL for your tables and sample data in the form of INSERT statements, as well as the expected results based on that sample data.Tue, 10 Sep 2013 09:43:59 GMTLuis CazaresPivot Help--I need to Pivot really to just make the rows the columnhttp://www.sqlservercentral.com/Forums/Topic1493263-338-1.aspx[code="sql"]SELECT CONVERT(varchar,C.SCHED_DTTM,101) as DATE,C.INV_ITEM_ID ,SUM(C.QTY_REQUESTED) AS QTYFROM PS_IN_DEMAND C WHERE C.SCHED_DTTM&gt;=GETDATE() AND C.IN_FULFILL_STATE IN (10,20,30,40) GROUP BY C.SCHED_DTTM,C.INV_ITEM_ID ORDER BY C.SCHED_DTTM,C.INV_ITEM_ID[/code][p]DATE INV_ITEM_ID QTY9/10/2013 W526R 29/10/2013 X426R 19/10/2013 6414 39/11/2013 2001-1 49/11/2013 2001-2 49/11/2013 2001-5 49/11/2013 10-1109R 19/12/2013 12401 19/12/2013 12402 19/12/2013 12405 19/12/2013 12406 19/12/2013 12433 19/12/2013 3801 1[/p]Tue, 10 Sep 2013 09:39:50 GMTtwdavis-893252