Maybe I'm just missing something here, but how can the above EVER return a zero?

Are you able to build a calendar or "dimDate" table? That will simplify this and similar queries that come up in the future.

Anybody? Any ideas? Bueller? Bueller?

Matt Miller (#4) (12/10/2014)

---

sqldriver (12/9/2014)

---

Grant Fritchey (12/9/2014)

---

Still trying to figure out what the use-case for multi-statement table-valued user-defined functions is. But, other than...

I wonder how the...

I would suggest that if your procedure is so complicated you need to step through it you can probably gain a lot by simplifying your code. Often times what I...

I do believe that this is a violation of the ANSI standard. Maybe not of the letter of the standard (I am not even sure if variables are included in...

Eirikur Eiriksson (12/8/2014)

---

Quick thought, if there...

It seems like you might want to consider doing this with a reporting tool rather straight out of sql server.

Hugo Kornelis (12/8/2014)

---

DonlSimpson (12/8/2014)

---

Hugo Kornelis (12/7/2014)

---

Ahem. Why not simply use a single SELECT?

SELECT @a = @b-2, @b-2...

Are you required to store the number with the formatting? It can be easier to apply the formatting when retrieving the phone number.

Hugo Kornelis (12/7/2014)

---

Ahem. Why not simply use a single SELECT?

SELECT @a = @b, @b = @a;

This won't...

Hugo Kornelis (12/7/2014)

---

There are good use cases for bitwise logic in SQL Server. This is not one of them.

Pretty good trivia question, but readers: please do not ever think about...

My other thought for a tagline was "Will Rogers never met Pete Rose."

🙂