Unpivotting Techniques in T-SQL - SQLServerFAQ's library

Details
Share
Attachments

Content: Video (mp4) - 5.55MB
Title: Unpivotting Techniques in T-SQL	Description: Rob Farley shows a few ways to unpivot data in T-SQL, including a look at the execution plans involved
Date: 6/27/2010 12:00 AM	Author: Rob Farley

Share URL:
Copy and paste this URL to share content with viewers. For example, paste into email or instant messages.

Embed on your page:
Copy and paste this HTML to embed this content into a web page or blog.

<!-- copy and paste. Modify height and width if desired. -->
       <object id="scPlayer"  width="640" height="434" type="application/x-shockwave-flash" data="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/Unpivot_controller.swf" >
<param name="movie" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/Unpivot_controller.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="#FFFFFF" />
<param name="flashVars" value="containerwidth=640&containerheight=434&showstartscreen=true&showendscreen=true&loop=false&autostart=false&color=000000,000000&thumbscale=45&content=http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/Unpivot.mp4&blurover=false" />
<param name="allowFullScreen" value="true" />
<param name="scale" value="showall" />
<param name="allowScriptAccess" value="always" />
<param name="base" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/" />
<iframe type="text/html" frameborder="0" scrolling="no" style="overflow:hidden;" src="http://www.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/embed" height="434" width="640" ></iframe>
</object>

<!-- copy and paste. Modify height and width if desired. -->
 <object id="scPlayer"  width="640" height="434" type="application/x-shockwave-flash" data="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/Unpivot_controller.swf" >
 <param name="movie" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/Unpivot_controller.swf" />
 <param name="quality" value="high" />
 <param name="bgcolor" value="#FFFFFF" />
 <param name="flashVars" value="containerwidth=640&containerheight=434&showstartscreen=true&showendscreen=true&loop=false&autostart=false&color=000000,000000&thumbscale=45&content=http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/Unpivot.mp4&blurover=false" />
 <param name="allowFullScreen" value="true" />
 <param name="scale" value="showall" />
 <param name="allowScriptAccess" value="always" />
 <param name="base" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/5c536f28-e44d-48da-be82-ba1047665953/" />
 Unable to display content. Adobe Flash is required.
</object>

Content size: width: px height: px reset

Unable to Share Private Content