If you go the mapping table route do a search for "cardinal ordinal number list" or "... chart"... You may get lucky as someone out there may have already done...

For a work-table free, sort-free, purely set-based way of handling this you could use getnumsAB[/url] and do this:

DECLARE @STARTDATE DATETIME = '06/05/2016',

@ENDDATE...

durga.palepu (6/13/2016)

---

Thanks, that's awesome solution.

Your approach to provide hints so that I would work on actual solution is excellent so that I could learn my self.

Here follow's my solution implementations:

using...

Just to add to what R.P. Rozema said...

Here is a good article about this technique for concatenating a string using this method: Creating a comma-separated list (SQL Spackle)[/url].

He's putting the example data into CTEs... It's the same as...

MikeS. (6/10/2016)

---

It's funny you should bring up the subject of 'nolock' -- at most places I've worked, it's a big no-no. At my current job, you'll get your hand...

Comment removed.

I missed the whole second page of this discussion...

Thank you very much. 😀

So now we know the window aggregate function is the culprit. Since we’re not partitioning the data yet (but will in a...

Nice article John. Well done.

Great article Hugo. Very well researched and written. I just started the series and look forward to the rest.

I have neen reading up on columnstore indexes recently and just read...

Jeff Moden (6/7/2016)

---

Heh... I love it! It's like a war cry! 😀

Very cool article, Alan. Well done.

Hat's off...

Ken Hiatt (6/7/2016)

---

Thanks Alan, it's always fun to learn faster ways to do things, even if it's not something I expect to be using 🙂

While my SQL programming skills are...

Thank you Kevin and Mauricio.

Thanks Eirikur!

Lowell (6/6/2016)

---

DennisPost (6/6/2016)

---

Hi Lowell,

Thanks for taking the time to read and reply.

That approach won't work for us as the server is set to UTC and we need to be able...