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

Blogs

SQLSaturday Orlando 2021 – September Update

By

Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today...

Audit Columns

By

One of the easiest ways to collect information about table activity is to add...

Daily Coping 28 Sep 2021

By

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

Read the latest Blogs

Forums

Issue with the change of the column precision to be 2 decimal places

By JeremyU

Hello, I need to  change the % sales vs forecast column precision to be...

Social Media Link Aggrigator

By suvina

Need a way to put all of your social media links and profiles into...

Implicit conversion from datetime to datetime2

By Alessandro Mortola

Comments posted to this topic are about the item Implicit conversion from datetime to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers