SQL Server Performance

Crosstab - Different approach

Discussion in 'The Lighter Side of Being a DBA' started by Madhivanan, Jul 10, 2007.

  1. Madhivanan Moderator

    <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
  2. FrankKalis Moderator

    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>
  3. satya Moderator

    [<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=':D' />], 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>
  4. Madhivanan Moderator

    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
  5. FrankKalis Moderator

  6. spirit1 New Member

    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>
  7. FrankKalis Moderator

    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>
  8. spirit1 New Member

    here, there... it's all one big place [<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>
  9. FrankKalis Moderator

    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>
  10. spirit1 New Member

  11. FrankKalis Moderator

  12. Madhivanan Moderator

    <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
  13. spirit1 New Member

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

    that's pretty close to iserlohn... our mother company is there.

    _______________________________________________
    Causing trouble since 1980
    blog:http://weblogs.sqlteam.com/mladenp
  14. FrankKalis Moderator

    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=':D' />]<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>
  15. spirit1 New Member

    &gt; Might be worth investigating.<br /><br />uu yes yes!! it sure might [<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>

Share This Page