Ok... I'll go the table route... I'm seeing more information that I could add.

So from the existing result of this "PROC" it always returns a single record... How...

Thanks for all... I'll look at making a calendar table.

My only issue with that is then I'm bound to lookup only dates in the table.. I can't throw...

Evil Kraig F (1/24/2012)

---

Yes, it's a function. You want a UDF, or user defined function. However, you need to be aware that inline functions like this are very...