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

Content with tags T-SQL, CASE Rss

   Items 1 to 9 of 9   
 

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 2015/06/05 (first published: 2012/04/26) | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 25,263 reads

Unravel Some Complex IF Logic

By Dwain Camps 2014/01/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,193 reads

CASE vagaries

By NT 2013/09/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,574 reads

Assigning categories to values 2

By Hugo Kornelis 2013/05/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,321 reads

Assigning categories to values 1

By Hugo Kornelis 2013/05/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,416 reads

Converting to datetime a char field with several possible date formats

Converting to datetime a char field having several possible date formats  Read more...
By Federico Iori 2013/02/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,574 reads

T-SQL: CASE Statement

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...  Read more...
By Jen McCown 2012/12/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,377 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 2015/06/05 (first published: 2012/04/26) | Source: SQLServerCentral.com | Category: case
Rating: |  Discuss |   Briefcase | 25,263 reads

SQL Server CASE Law

SQLs CASE expressions can be powerful magic, but can trap the unwary that are used to the more familiar CASE statements of procedural languages.   Read more...
By Additional Articles 2011/03/14 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,678 reads
   Items 1 to 9 of 9   
 
Tags
blogs (1)    
convert (1)    
date manipulation (1)    
datetime (1)    
order (1)