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

Content with tags Stored Procedures, Temporary Tables Rss

   Items 1 to 3 of 3   
 

SSIS and Stored procedures using temp tables

SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.  Read more...
Rating: |  Discuss |   Briefcase | 13,349 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 | 898 reads
   Items 1 to 3 of 3   
 
Tags
dynamic sql (1)    
execute (1)    
integration services (ssis) (1)    
nested loop (1)    
parameters (1)    
pivot (1)    
report (1)    
statistics (1)    
temp tables (1)