If you're able to have multiple dates passed to the procedure, you're receiving them as varchars. Here's an approach to handle multiple dates being that aren't necessarily in chronological...

Don't get me wrong - I thought it was a good question, but a poorly-worded and misleading implementation.

I have to agree with Koen. On site means on site, not Azure - plain and simple.

Risotto

Sean Lange (6/17/2014)

---

The security portions of that POS may be fixed but the rest of it still sucks. As I am primarily an ASP.NET developer we write our stuff to...

Eirikur Eiriksson (6/17/2014)

---

Grant Fritchey (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Eirikur Eiriksson (6/17/2014)

---

Sean Lange (6/17/2014)

---

SQLRNNR (6/17/2014)

---

Did you notice that the "Active Threads" on your inner window was missing?

My active threads has been missing most of...

Oh great, the soccer spam has returned. I'm starting to feel like the spam police. I reported a bunch of them so (hopefully) they'll be easier to find...

Luis Cazares (6/17/2014)

---

I agree with most people on avoiding being the single person that knows everything and the ultimate problem solver.

However, I would like to encourage another point of view....

Cooking

Okay, now that's just plain weird. I've never seen that one before. I wonder...if you get the two windows logged in under a different account, which account would...

Games

Is the application using functions (or anything else) in other databases? If you granted db_owner to the login in the application's database, the login can use any table, procedure,...

GilaMonster (6/17/2014)

---

Simple, I make very, very sure that I'm not indispensable.

I make sure that others can do the majority of what I do, doesn't have to be as...

CTEs solve so many problems. Thanks for the question.

Andy, your questions are usually thought-provoking, so thank you. It's a good way to wake up my brain.