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

Content with tags T-SQL, DateDiff Rss

   Items 1 to 2 of 2   
 

Cursor-Killing: Accessing Data in the Next Row

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.  Read more...
By Edward Pollack 2014/05/27 | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 11,855 reads

Date Manipulation with DATEADD/DATEDIFF

Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.  Read more...
By Seth Phelabaum 2010/04/07 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 17,314 reads
   Items 1 to 2 of 2   
 
Tags
cte (1)    
cursor (1)    
date manipulation (1)    
dateadd (1)    
lag (1)    
lead (1)    
window function (1)