Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Stored Procedures, Execute Rss

   Items 1 to 2 of 2   
 

EXECUTE

By Steve Knox 2014/12/09 | Category: execute
Rating: (not yet rated) |  Discuss |   Briefcase | 1,500 reads

Demonstration on how to pivot data using temp tables

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)  Read more...
By Chris Morton 2008/10/10 | Source: SQLServerCentral.com | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 903 reads
   Items 1 to 2 of 2   
 
Tags
dynamic sql (2)    
nested loop (1)    
parameters (1)    
pivot (1)    
report (1)    
temporary tables (1)    
t-sql (1)