Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a CASE WHEN in a WHERE clause
Message
From
30/07/2015 09:08:26
Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada
 
 
To
30/07/2015 08:48:39
Sergey Berezniker (Online)
New York, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Adding a CASE WHEN in a WHERE clause
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01622652
Message ID:
01622688
Views:
31
>My guess is that execution plan is not optimal for both cases. Why don't you split in 2 statements?

Yes, that is what I thought as well. That is correct, when using two statements, everything responds accordingly.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform