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

Articles with tag order Rss

Search for any content tagged order

   Items 1 to 2 of 2   

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,998 reads

Demystifying the use of CASE in an ORDER BY statement

Chuck Hoffman exposes the mysteries of getting CASE statements to work in dynamic ORDER BY statements.  Read more...
By Chuck Hoffman 2012/04/26 | Source: | Category: case
Rating: |  Discuss |   Briefcase | 14,965 reads
   Items 1 to 2 of 2