Use DATEADD, with a negative number of days.

select getdate(),DATEADD(day,-3,getdate())

Question: In SSC, is the proper acronym "LOL" (laughing out loud) or "SOM" (spewing on monitor) ??

If I can't build a reputation on SQL skills, I am forced to build one on bad puns. 😛

I think I will start referring to you as Emperor Paulpatine.

Many thanks, Paul.

Grant, I liked this question, even though I got it wrong. 😉

Okay, I'm in synch with your question now. Sorry for the confusion. It seems to be my day for it.

Thanks Paul, I was missing that. Thanks for fixing the image. Also, do you disagree with what I said about the size of the RID? ...

PP:

I see two queries against different columns. What does that prove?

Also, do you have an index built over either date column? That...

Hey Chris,

Thinking about your results, the table itself is smaller than the index in this case. Why? Because the underlying table has no clustered index....

I will suggest that you give us an example using sample tables and data, to accompany your picture of what the expected output should be. Simple text...

If the index were a clustered index, I would agree. But rememeber that you often see...

I just got long-winded and gave a lecture here about how execution plans differ depending on the size and nature of the data. If anybody would care to...

I see that different people are seeing different results.

On my machine, at 100 rows, the 4th query (against #bigT) produces an index seek, and an RID lookup,...

the question is not a simple one of the structure leading to a deterministic result, but the optimiser may take very different routes in the same database structures depending on...

Winston, I think we need you to clarify something about your requirements. I noticed that you had one itemID that was associated with two different groupIDs.