I know what you're trying to do. What you fail to understand is that to get the correct calculation, you need to be able to define how to calculate week...

It probably needs to be more like this to include all the possible hours.

DECLARE @StartDate datetime = '20010101',

@EndDate datetime = '20010107';

WITH

E(n)...

Jeff Moden (10/2/2016)

---

Just curious.... what are you doing that needs so many APPLYs?...

The way you define week 1 will change the week number....

What's the problem? You could have 30 million employees and their salaries for several...

How do you define week 1?

That's not possible without dynamic SQL. That's a bad idea, though.

Drop the default and recreate it.

CREATE TABLE SampleData(

[EmailDate] [datetime] NOT NULL CONSTRAINT [DF_OnlineDay10_EmailDate_GETDATE] DEFAULT (CONVERT([date],getdate(),0))

);

INSERT INTO SampleData VALUES(DEFAULT);

ALTER TABLE SampleData DROP CONSTRAINT [DF_OnlineDay10_EmailDate_GETDATE] ;

ALTER TABLE SampleData...

Different options.

SELECT v.*

FROM (

VALUES

(1, 'True', 'True', 'True', 'True', 'True', 'True'),

(2, 'True', 'True', 'True', 'True', 'True', 'True'),

(3, 'True', 'True', 'True', 'True', 'True', 'True'),

(4, 'True', 'True', 'True', 'False', 'False', 'True'),

(5, 'True', 'True',...

Sorry Gianluca, I'm just trying to bring the young padawan into the dark side....

Don't listen to that, download the developer edition of SQL Server which is free if you just create a (free) account here: https://www.visualstudio.com/dev-essentials/

I don't see any reference to Oracle and this is a SQL Server site.

I can't picture a situation in which a CASE statement could be the only option in a WHERE clause.

I, however, can see a lack of understanding of SQL. I said...

drew.allen (9/26/2016)

---

xr280xr (9/26/2016)

---

I don't specifically care about short circuiting. I just need to only evaluate b if a is false and only evaluate c if a and b are false....

If you can't change the database design, you need to use dynamic sql to recreate the view constantly.

Here's an idea for a trigger.

IF EXISTS(

SELECT *

...