Post reply

Trying to UnPivot without using multiple selects unioned together

  • November 6, 2009 at 6:31 pm

    #1076193

    Wow... I wander off and enjoy the PASS Summit and come back to find this !? Why don't one of you guys take this opportunity to write a "Beyond Unpivot" article?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • November 6, 2009 at 9:24 pm

    #1076223

    Hey Bob,

    I think we pretty much did already 😉

    Glad you enjoyed PASS.

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • November 6, 2009 at 11:16 pm

    #1076251

    I'll say you did. The end result is sweet, too.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • September 23, 2010 at 3:55 pm

    #1226632

    Hey Paul, I revisited this and noticed that your last post replaced the cross apply of a VALUES clause with a subquery containing a lot of SELECT/UNION all statements. I'm assuming this was for performance reasons, but could you elaborate?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • September 23, 2010 at 11:57 pm

    #1226716

    The Dixie Flatline (9/23/2010)

    Hey Paul, I revisited this and noticed that your last post replaced the cross apply of a VALUES clause with a subquery containing a lot of SELECT/UNION all statements. I'm assuming this was for performance reasons, but could you elaborate?

    No, there's no difference - I just wanted the final query to be compatible with SQL Server versions prior to 2008.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 24, 2010 at 5:53 am

    #1226875

    Understood. Thanks for taking the time.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 6 posts - 46 through 50 (of 50 total)

You must be logged in to reply to this topic. Login to reply