SQL Clone
SQLServerCentral is supported by Redgate
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 | 14,597 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 | 961 reads
   Items 1 to 3 of 3   
dynamic sql (1)    
execute (1)    
integration services (ssis) (1)    
nested loop (1)    
parameters (1)    
pivot (1)    
report (1)    
statistics (data) (1)    
temp tables (1)