Thank you so much! This works great! Jamie

Never mind! Thank you anyway. 🙂

Any thoughts on the sql server agent / default profile for dbmail? One of my clients removed the builtin administrator and all the jobs we had running have failed....

I'm not sure why this problem was happening but I finally just decided to put all the data in a permanent table and I after that I had no problems....

Thank you so much!  I did have the month number.  Just wasn't going about it the right way.  Thanks again!! Jamie

That would be because our CFO/CIO wants EVERYTHING automated .  I was wondering if I could first setup a task to basically copy and...

They are the same data type.  I looked at it today and was able to get it to come over.  I'm not sure what I did wrong in the beginning. Thanks...

Here's my code.  The goal is to have one column of 'Job Code' first looking at JobCodeInput if null then JobCode.  I can't combine them because there is always a...