That will work great, thanks for the help.

I ended up using a script function to get the return value and handle it if it is a null value with code.

Thank's for the reply.

Thanks for the help. I didn't know about the multicast transformation and that is exactly what I need.

Thanks for the help everybody, I really appreciate it. You saved me a lot of frustration and time. I also had not heard of the CTE's in SQL 2005.

Chris

Sorry about that, I wasn't very clear before (in my mind I knew what I meant :-)). I need a sum per day for the whole month so the output...