I've worked with a dates table to find "missed" days, and also used CTES to generate sets of dates on the fly using a tally table to increment some...

As long as we're mentioning 2005, you can just order by the assigned name of your calculated column without bothering with a CTE. The following runs just fine...

The horror... the horror...

😛

Winash, I would have gone with not like '%[0-9]%' being most elegant. What have you got that tops it?

Clarification please. Do you want to select only rows without numbers or do you want to return all strings, only with numbers removed?

The CTE "Days" is an example of a "Recursive" query. Just search the word "recursive" in the search block above and you will find a number of...

Please help us out by telling us what "Some Error" is.....

Remember, we don't have your tables on our servers, so we can't just cut and paste your code into a...

Porkchop Traumatic Stress Disorder

If he moves the USE, won't the variables be okay? Looks like all he's doing is getting values for today and yesterday.

Try moving that USE docnet to the first line of your query, it's just good practice.

Now

[font="Courier New"]

WHERE do.LastModifiedTime BETWEEN @Yesterday AND @Today

AND en.DischargeDate <>...

You're welcome. I just want to make it clear that I don't recommend it in any situation where performance is, or may become, an issue. ...

My intention was to suggest something that would perform well, since simple is going to run poorly.

Here is the original suggestion from my first post.

It is...

I deleted my earlier query because I forgot to think outside the box. Can you work with this?

declare @integrityTbl table (integrity int primary key)

if @integrity = 'all classified'

...

:w00t: