They are old school, which I can appreciate, but you are just wasting CPU cycles.

Hey again Trudye,

We really need to get you out of this idea that dates have to be converted to strings. 😉 Try this:

SET @First_Day_Prev_Month =...

Hey Barry, I hope you are well along the road to recovery/rehab for your back now. Everything going okay there?

You could do it in dynamic SQL and probably get better performing results, but otherwise it is as simple as

WHERE @flag = 0 and filter = 2

...

Jack,

We're all really happy to hear your little girl is doing fine. 😀

Let's hope that's the last time you have to contend with a real injury. ...

Hang in there, Jack.

God bless you all, Jack. We'll say a prayer for her speedy recovery.

Absolutely not. I haven't worked with one in forever.

So true, Alvin. 🙂

By the way, thanks for everyone's insights. I always thought that relational was the db model of choice because of flexibility and because it...

After well nigh unto 9,000 posts, The Thread has taken many turns. The other forums do the same things. Don't sweat it, the pendulum will swing...

I'll second Jeff's request. Long involved verbal descriptions can't take the place of sample schema, a script to populate sample data, and a visual of what the expected...

It's not simpler than

CREATE dbo.DoomsdayTable (data xml) 😎

First, there is a concept you need to understand:

Rows in SQL result sets have no "original" order, other than that which you impose on them with an...

Hi Mattie:

Next time, PLEASE cut and paste the statements you took a screen shot of. It's lovely, but it forces us to retype everything before we can play...

Could we see some code and sample data?