Sotiris Filippidis

  • Interests: .NET, SQL, Guitar (a bit)

Conditional Statements in WHERE Clauses

T-SQL is a powerful language, enabling you to handle many different types of set based operations. But having flexible WHERE clauses isn't something that many DBAs deal with on a daily basis. New Author Sotiris Filippidis brings us an article on how you can structure a WHERE clause to handle all types of strange business logic without using dynamic SQL. Read on to learn more about his technique.

3.62 (53)

2007-09-28 (first published: )

34,344 reads

Blogs

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Goal Progress for April 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Daily Coping 7 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Upgrade 2014 Web Edition to Standard

By @SQLNumpty

Hello. I'm working with a client who currently has a SQL 2014 Web Instance...

Package failing but the table is already there and the system says its missing!!

By hurricaneDBA

Dear Everyone Im using SSIS 2019 and VS 2019 The data scientist gave me...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers