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

Content with tag Execute Rss

   Items 1 to 2 of 2   

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,245 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: | Category: dynamic sql
Rating: |  Discuss |   Briefcase | 901 reads
   Items 1 to 2 of 2   
check constraint (1)    
create (1)    
dynamic sql (1)    
foreign keys (fk) (1)    
indexing (1)    
nested loop (1)    
parameters (1)    
pivot (1)    
primary key (pk) (1)    
report (1)    
stored procedures (1)    
table (1)    
temporary tables (1)    
t-sql (1)    
unique (1)    
xml (1)