Crosstab - Different approach

<br />This seems interesting [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /<a target="_blank" href=http://www.stephenforte.net/owdasblog/PermaLink.aspx?guid=2b0532fc-4318-4ac0-a405-15d6d813eeb8>http://www.stephenforte.net/owdasblog/PermaLink.aspx?guid=2b0532fc-4318-4ac0-a405-15d6d813eeb8</a><br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

No, I don't agree with you. You're digging out old stuff here. [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br />That method utilizes something called "Characteristic Functions" or "Indicator Function" (Google on this!) and is unnecessary complex as it can easily be replaced with CASE expressions, or PIVOT().<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

[<img src='/community/emoticons/emotion-1.gif' alt='' />] Madhi has too much time in his hands after achieving MVP [<img src='/community/emoticons/emotion-2.gif' alt='' />], good catch Frankie.<br />As mentioned check BOL for update.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>

Well. I didnt specify that the method is effecient [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br />Thanks [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

I use this technique quite a lot when doing my Excel matrix calculations. There it is quite good.

--
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
Webmaster:http://www.insidesql.de

Fully agree with Adam <s>here</s> there in your blog. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

True. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>

Between Düsseldorf and Wuppertal in a town called Haan.

--
Frank Kalis
Microsoft SQL Server MVP
Contributing Editor, Writer & Forum Moderatorhttp://www.sql-server-performance.com
Webmaster:http://www.insidesql.de

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by spirit1</i><br /><br />i've posted about that a while ago:<br /<a target="_blank" href=http://weblogs.sqlteam.com/mladenp/archive/2006/06/14/10215.aspx>http://weblogs.sqlteam.com/mladenp/archive/2006/06/14/10215.aspx</a><br /><br />read the comments, kind of fun [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />_______________________________________________<br />Causing trouble since 1980<br />blog:<a target="_blank" href=http://weblogs.sqlteam.com/mladenp>http://weblogs.sqlteam.com/mladenp</a><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Thanks Mladen. I didnt know that you already blogged it [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail

The world is a village. <br /><br />Make sure to drop me a note when you're there next time. I've heard rumours that they brew beer there in Iserlohn. Might be worth investigating. [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br />Contributing Editor, Writer & Forum Moderator<a target="_blank" href=http://www.sql-server-performance.com>http://www.sql-server-performance.com</a><br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>