SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, DateDiff Rss

   Items 1 to 5 of 5   
 

Avoiding Unexpected Results with DATEDIFF in Year Comparisons

Learn how to avoid unexpected results when using the DATEDIFF function to find the difference between two dates in years.  Read more...
By David Strack 2018/04/09 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 1,322 reads

Using Mod to Generate Work Shifts

A short story on using the mod function to a shifting query.  Read more...
By Joe McGovern 2016/12/22 | Source: SQLServerCentral.com | Category: mod
Rating: |  Discuss |   Briefcase | 1,395 reads

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 2015/12/18 (first published: 2014/05/27) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 22,033 reads

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 2015/12/18 (first published: 2014/05/27) | Source: SQLServerCentral.com | Category: cte
Rating: |  Discuss |   Briefcase | 22,033 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,652 reads
   Items 1 to 5 of 5   
 
Tags
dateadd (2)    
cte (1)    
cursors (1)    
date (1)    
date manipulation (1)    
lag (1)    
lead (1)    
mod (1)    
sql server (1)    
window functions (1)