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

Content with tags T-SQL, order Rss

   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: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 10,862 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: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 14,950 reads
   Items 1 to 2 of 2   
 
Tags
case (1)    
cumulative (1)    
over (1)    
partition (1)    
sum (1)