Crosstab Pivot-table Workbench


	Crosstab Pivot-table Workbench

travislaborde

3-19-2008 7:54 AM

282 views

tags:

programming, sql

travislaborde says:

Great article, but WAY more TSQL than I ever want to write

Add a Comment

Login to Comment. Not a member yet? Sign up

View the Top Clips from March 19, 2008

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/fce756cb-2772-4368-8661-b2ee1adf101e/48CEA204-8A35-4F68-BDEC-3D6A44A72DC3/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/" href="http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/" style="font-size: 11px;">www.simple-talk.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/"><DIV class="articletitle">Crosstab Pivot-table Workbench</DIV></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/">There comes a time with many Database Developers charged with doing management reports when the process of doing it properly gets very tedious.</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/"><P>Anyone who was weaned on Excel knows that these pivot tables are dead simple. You select your data, bang the button and with a bit of dragging and dropping, there it is. Why, they ask, is it so hard to get it out of the database? Why so hard to make changes? </P></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/"><DIV id="MyCrosstab">
<H3>No. Sales per year</H3>
<TABLE cellspacing="0" cellpadding="0"><THEAD><TR class="header"><TH> </TH><TH>1996</TH><TH>1997</TH><TH>1998</TH><TH>Total</TH></TR></THEAD><TBODY><TR><TD class="rowhead">Margaret Peacock</TD><TD class="number">31</TD><TD class="number">81</TD><TD class="number">44</TD><TD class="number total">156</TD></TR><TR><TD class="rowhead">Janet Leverling</TD><TD class="number">18</TD><TD class="number">71</TD><TD class="number">38</TD><TD class="number total">127</TD></TR><TR><TD class="rowhead">Nancy Davolio</TD><TD class="number">26</TD><TD class="number">55</TD><TD class="number">42</TD><TD class="number total">123</TD></TR><TR><TD class="rowhead">Laura Callahan</TD><TD class="number">19</TD><TD class="number">54</TD><TD class="number">31</TD><TD class="number total">104</TD></TR><TR><TD class="rowhead">Andrew Fuller</TD><TD class="number">16</TD><TD class="number">41</TD><TD class="number">39</TD><TD class="number total">96</TD></TR><TR><TD class="rowhead">Robert King</TD><TD class="number">11</TD><TD class="number">36</TD><TD class="number">25</TD><TD class="number total">72</TD></TR><TR><TD class="rowhead">Michael Suyama</TD><TD class="number">15</TD><TD class="number">33</TD><TD class="number">19</TD><TD class="number total">67</TD></TR><TR><TD class="rowhead">Anne Dodsworth</TD><TD class="number">5</TD><TD class="number">19</TD><TD class="number">19</TD><TD class="number total">43</TD></TR><TR><TD class="rowhead">Steven Buchanan</TD><TD class="number">11</TD><TD class="number">18</TD><TD class="number">13</TD><TD class="number total">42</TD></TR><TR><TD class="sumrow rowhead">Sum</TD><TD class="sum number">152</TD><TD class="sum number">408</TD><TD class="sum number">270</TD><TD class="sum number total">830</TD></TR></TBODY></TABLE></DIV></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/48CEA204-8A35-4F68-BDEC-3D6A44A72DC3/blog/" title="blog or email this clip"><img src="http://content9.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Blog; Copyright; Privacy; EULA

Search Options

Related Clips

More clips from travislaborde

Today's Top Clips