drew.allen (9/28/2011)

---

Actually the problem lies with this piece of code:

DATEADD(wk, DATEDIFF(wk, 0, GetDate()), 0)

Similar code...

thang_ngo_2002 (9/28/2011)

---

When I assign this user to "public" of master, and select for this log-table. I login successfully

But how can I define which login with correct password, which login with...

Sean Lange (9/28/2011)

---

All I did was added some ddl and data in a consumable format and ran the query exactly as the OP posted it and it returned the exact...

WayneS (9/27/2011)

---

Steve Jones - SSC Editor (9/27/2011)

---

WayneS (9/27/2011)

---

Hey Threadizens... I received an email for what looks like an interesting permanent/full-time DBA position in the Phoenix area (I know some of...

It looks like Dereks chess algorithm needs an update. :-D:-D:-D

Good luck and may the plane be with you.

You're welcome 😎

As I said - I already noted it once. Maybe this is another good reason to hire a consultant....

Kingston Dhasian (9/28/2011)

---

This should work for you then..

DECLARE @from_date DATETIME

SET @from_date = '11-Sep-2011'

SELECT CASE

WHEN DATEADD( MONTH, DATEDIFF(...

That wasn't working in this query. Only Sunday...

It appears there is an issue with how SQL handles dates that land on Sunday. Here is a klugy workaround.

DECLARE @from_date DATETIME

--Set DateFirst 1 --tried this but it had...

See my last reply where I provided the answer (the change needed to make Seans query work for you).

Please provide sample data so we can test solutions.

Does the Rooms table have arrival dates and departure dates? You could also try throwing on the where clause:

or ClientRoom.ArrivalDate is null

The fix for that is quite simple....