Sql Server: Case statement to Sort records by different columns of different data types

Introduction :  Here in this article I am going to explain how to use CASE statement in Order by clause to sort records with different colu...

Sql Server: Using case expression in order by clause to sort records

Introduction :  Here in this article I am going to explain how to use CASE statement in Order by clause to sort records as per requirement....

SQL Statement Equivalent to Ternary/Conditional Operator

Introduction:  In this article I am going to explain how to use alternative of ternary or conditional operator which is not available in S...

Sql Server: Using CASE Statement inside IN Clause (alternative)

Introduction :   In this article I am going to share best alternative of using CASE statement inside IN operator in sql server with suitab...