I'd say it's a bug.

3 or 4 years ago it was a big discussion here. At that time current version of SQL Server was doing OK by following ANSI standard...

All the inputs are 2 bages back.

Please make an effort to read what people answer on your questions.

Now you need to LEFT JOIN to holidays.

What kind of joins you're aware of?

lee.pollack (3/10/2009)

---

Just looked up scope_identity. Nice, except for one thing - no yelling now, I did not right the program, there tables DO NOT seem to have any identity...

First of all, replace ISNULL(colN,0)<NNN with (colN<NNN or colN IS NULL).

For English in Australia it's 1 - Monday.

It depends not...

You use "sysname" datatype for some strings (@rownamesalias, for example).

Sysname is actually nvarchar(128)

Try always set a clustered index on the column(s) used in range selections.

In your case its [DateTime].

Clustered index on that column will resolve the problem.

See the first reply.

You have nvarchar somewhere.

How do you execute @sqlstring?

IF OBJECT_ID('tempdb..#Table') IS NOT NULL

DROP #Table

Michael Valentine Jones (3/3/2009)

---

After I corrected that, it looks to me like my code is the only one returning the correct results:

The latest Monday on or before the current date,...

Actully, Lynn, it's much easier.

If based on my code. 😎

DECLARE @Date datetime

SET @Date = GETDATE()

SELECT @Date as [Date], WeekStart, WeekStart + 4 as WeekEnd

FROM (

...

Actually finding the beginning of current week should not be any different as finding of the beginning of current day.

DECLARE @Date datetime

SET @Date = GETDATE()

select @Date as [Date], DATEADD(wk,...