J-thanks! i'm always up for learning new ways to do things.

Jeff - Like I just said to J, I'm always up for learning new ways of doing things....

Jeff Moden (3/31/2008)

---

The only thing that can be faster than the Tally Table is Dynamic SQL... but that's not a split and it does have some security issues if it's...

Jeff, I must have just missed your reply. I will read up on the tally table. thanks!

Thanks all for the suggestions.

Sergiy, I was able to assign the values by using your example but I still couldn't pass them into the query.

rbarryyoung, I didn't...

I was able to figure out a way to achieve the results I wanted. I used a few datepart functions and a derived query.

Thank you for the quick reply. I appreciate it. I will go the route of creating the link tables.

Wow!  Thanks for all the responses.  It looks like I have a lot of different avenues to take.  I'll take a look at all options and i'll post back with...

Thanks, I will give it a try.

Thank you both for the replies. Honestly, I am really a novice with SQL. I'm using SQL Query Analyzer and I plan to dump the results into excel and...