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

Articles with tag over Rss

Search for any content tagged over

   Items 1 to 2 of 2   

Convert Rows into Columns

Convert the rows of a SELECT statement into a predetermined number of columns.  Read more...
By M Patrick Dillon 2014/07/17 | Source: | Category: rows to columns
Rating: |  Discuss |   Briefcase | 14,634 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2014/05/08 | Source: | Category: cumulative
Rating: |  Discuss |   Briefcase | 10,996 reads
   Items 1 to 2 of 2