Would something like this work? I wrote it in "notepad" so not sure if syntax is correct...

SELECT *

FROM Table

WHERE Time_Open <= GETDATE()

AND Time_Open >= DATE_SUB(MONTH, DATEDIFF(MONTH, 0, GETDATE()) -...

Such a simple question, but it made me think... There has to be a way to do this via date_sub, or datediff isn't there? I'll work on it, fun/valuable...

Thank you for article, enjoyed the read!

Jeff Moden (1/12/2014)

rho_pooka (1/11/2014)

Jeff Moden (1/11/2014)

Although it may seem so, I'm not being sarcastic at all when I ask you, do you know what "Books Online" is? People who...

Even better, thnx again!!

Jeff Moden (1/11/2014)

Although it may seem so, I'm not being sarcastic at all when I ask you, do you know what "Books Online" is? People who ask the kinds...

Thank you, I haven't drilled into dynamic sql yet… will revisit this once I do.

-Ben

I see now, thanks for help!

Thanks for such prompt replies all!

Koen, isn't the query that I had written a test just like your second example?

Struggling with this one, thanks again for help.

First post here, glad to be a part of this community.

I had my first go at the 70-461 exam yesterday and had an unfavorable outcome. I am...