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,319 reads

Blogs

T-SQL Tuesday Retrospective #005: Reporting

By

A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....

Daily Coping 25 Nov 2020

By

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

Database DevOps Deployment to Azure–Webinar

By

You can register now, but on Dec 3, I have a webinar with Microsoft...

Read the latest Blogs

Forums

How to know which index is invalid index on a table?

By 892717952

There are about thirty fields in a table SaleOrderLines, I created some indexes ,...

Thanksgiving 2020

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving 2020

Thanksgiving Visualizations

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thanksgiving Visualizations

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers