InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 16:41:16 GMT20http://www.sqlservercentral.com/Forums/Topic260419-288-1.aspx<P>Good intro. Thanks. </P><P>I've got a question, though. Given this statement from your article:</P><P>INSERT INTO SalesByPersonSELECT SalesPersonID, [2002],[2003],[2004] FROM Sales.SalesSummarryPIVOT(SUM(SubTotal) FOR OrderYear IN([2002],[2003],[2004])) as SalesPivot</P><P>is the IN (.....) required? What if I don't know the values and/or the values change? Am I stuck with dynamic SQL? Could I maybe put a sub-query (i.e. select DISTINCT OrderYear) in there?</P>Thu, 11 May 2006 14:53:00 GMTPam Brisjarhttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspxHi All,I'm working on second installment of this series now. Just wait <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>Fri, 31 Mar 2006 02:52:00 GMTMuhammad Choirul Amrihttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspxi look farward for more. thanks !Wed, 29 Mar 2006 23:28:00 GMTSunil Latharhttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspxHi Paul,thanks for the correction of the typo.The query still works fine, but order year 2001 will be interpreted as 2002 <img src='images/emotions/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>.It should be like this:SUM(CASE when OrderYear = 2002 then SubTotal ELSE 0 end) as '2002',Wed, 29 Mar 2006 22:31:00 GMTMuhammad Choirul Amrihttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspx<P>Thankyou I found your article very helpful and presented in a clear style. I look forward to reading more of your work</P><P> </P>Wed, 29 Mar 2006 14:02:00 GMTJim Bradyhttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspxThanks for the examples. In case anyone is working through them, the case statement has a typo with a '2002' replaced with a '2001'Wed, 29 Mar 2006 08:41:00 GMTPaul Ehttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspxI look forward to more...thanks!Wed, 29 Mar 2006 08:12:00 GMTed_elfrinkhttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspx<P>Clean and clear demonstration of such a useful feature...</P><P>Thank you</P>Wed, 29 Mar 2006 07:14:00 GMTDuray AKARhttp://www.sqlservercentral.com/Forums/Topic260419-288-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/mcAmri/sqlserver2005forsql2kdeveloperpart1.asp">http://www.sqlservercentral.com/columnists/mcAmri/sqlserver2005forsql2kdeveloperpart1.asp</A>Tue, 21 Feb 2006 14:58:00 GMTMuhammad Choirul Amri