SrcName (9/20/2013)

---

read this fantastic article carefully. This may help you

http://www.sqlservercentral.com/articles/T-SQL/62867/%5B/quote%5D

SrcName - thank you for the link, I have read this before and am familiar with the numbers/tally table. I'm not sure though how it helps me here, does not having a SARGABLE where clause cause a scan whatever I do?

Sorry, I haven't used the tally table enough to see its application here.

I would be very grateful if you could elaborate please.

thank you

D.