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

Scripts with tag Reference Rss

Search for any content tagged reference

Add a script

   Items 1 to 2 of 2   
 

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2012/10/08 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 2,622 reads

Date Calendar

Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.  Read more...
By Sean Smith 2010/07/21 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 5,208 reads
   Items 1 to 2 of 2