Maybe someone else will dig through your code but after 64 visits and 42 posts I'm sure you've heard the lecture about DDL and consumable data. Not providing that makes...

I posted a couple thoughts about Spam - I was wondering what other people's thoughts were:

Haha - my first good laugh of the day.

---

My thought on this is that it's a SQL related problem (people who unwanted records are...

I just read this for the first time this morning. Very informative and we'll written. Great work Jason.

Forgive me for reviving an 8 year old forum but here's a brand new, well tested and high-performing translate function: Translate8K[/url]

Hard to say... I am assuming this is a Production environment, correct? If so, why not try this in a Dev environment first? Why not run through this a...

Hello and welcome to SSC. Please note the link in my signature line for the best way to get help here. If you can include the DDL for the tables,...

Chad Crawford (5/12/2016)

---

I think of certifications as one leg on a four legged stool. The other three legs are experience, education and community (blog/forum/twitter/etc.). If you only have one...

I seem to have misplaced the crystal ball. Anyone want to look at this: http://www.sqlservercentral.com/Forums/Topic1785774-392-1.aspx#bm1785786

I think what ChrisM posted should help you.

Can you post what the desired output should look like?

I'm using a temp variable so you can easily copy/paste this code and run it locally. Note that you need to have delimitedsplit8K created for this to work.

DECLARE @cap2 TABLE...

drew.allen (5/11/2016)

---

Alan.B (5/11/2016)

---

drew.allen (5/11/2016)

---

Actually, an inline table-valued function based on a table value constructor (like in Luis' script above) is blazing fast. Much faster than any physical table, because...

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

TheSQLGuru (5/11/2016)

---

Eric M Russell (5/11/2016)

---

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and...

Now that I'm at a computer....

Not knocking Luis' solution but calendar tables are perfect for this kind of thing as they are highly reusable and even more simple than a...