GilaMonster (4/1/2009)

---

Nope, that's 2005 or 2008. There's a CTE and a pivot in there. I'm requesting a move...

FYI. Those of us that provide free help usually monitor the Active Threads which shows all threads from all forums. Multiple posts simply fragments the responses you get...

Actually, triple posting. I saw the third one, which is the one you had replied.

jcrawf02 (4/1/2009)

---

GSquared (4/1/2009)

---

Lynn Pettis (4/1/2009)

---

Geez, some people with no sense of humor. I read it thinking it was a real horror story unfolding on a poor DBA. Glad...

Sorry, triple posted! Please, only post your request for help ONCE! Please post further replies here.

Can you provide us with more details, like the complete error message.

Hey Bob! He's back!

Without the code for your stored procedure, table structure (CREATE TABLE statements), sample data, and expected results there isn't much we can do to help you.

Please do not double post. Please post replies here.

Geez, some people with no sense of humor. I read it thinking it was a real horror story unfolding on a poor DBA. Glad to see it was...

How about providing ALL the code not just snippets? From what you have posted, I have no idea why it didn't work.

Does this mean that the posts may be gettng better, or are we just showing greater tolerance for the moment??

Does this code help:

declare @ThisDate datetime;

set @ThisDate = getdate();

select dateadd(wk, datediff(wk, 0, @ThisDate) - 1, -1), -- Beginning of previous week (Sunday)

dateadd(wk, datediff(wk,...

Can you provide a concrete example of what you are talking about? For instance, what dates would be used today (2009-03-31) if either or both paramteres are null.

JJ B (3/31/2009)

---

I'm not sure most people made bad choices. there are always some that made poor financial choices, but buying a larger car, or a less efficient car because...