Question. Where did group_indicator come from? Did you add a column?

Hi Drew,

Thanks. This will get me in the ballpark.

Thanks a bunch!!!! 🙂

drew.allen (11/4/2016)

---

Both Mark's and Kevin's solutions use a non-SARGable join. Here is a version where the join is SARGable. It also allows for variable length ranges. If...

TheSQLGuru (11/4/2016)

---

A Numbers table of course! 😛

1-n with clustered index on that column. Gets you the same thing as the virtual one using...

Hello Guys,

Thanks for the posts. Both worked great!

Thank you 🙂

Wrong post

Hello

What is the Kgb.Numbers table?

Thanks Mark