Yeah, I discovered this yesterday. I was running around frantically and my network admins were trying to find good copies in the nightly backups and suddenly! bam! there they were....

Should I be looking at any third-party products to make this easier, or is everything I need built into SQL server?

You should probably post whatever your current solution is so we can look at it.

Extremely busy. =)

Steve, you've been helpful as always. Thanks again, everyone. I changed it to just dump everything into a temp table at the end and I get my values...

I know this one is a doosy, but it's not run constantly. It's part of a paper-tracking product and this is a manager's report for the most part. The flexibility...

I'll post the code, but it's a little ugly at this point...

I think I may have to take your suggestion of sticking this in a temp table.

--new variables for date...

Thanks again for your help, Steve!

Well, the beauty of the business day lookup table is that it *never* has to change. Monday is always 3 business days (depending on how you want to count it)...

Steve -

Thanks for your help. You got me on the right track, but my report is kind of a wierd one. I tried your method along with a brute...

I had that idea, but I wasn't sure how to join it exactly, since I'm using a date range. Could I join it on the month?

something like this:

on datepart(month, @date1)...

Thanks!! That looks like it will do the trick. Any ideas for how I might be able to exclude holidays listed in a table?

Ok, I kind of get it... but I'm still a little confused. What I'm doing in this case, is selecting how many of our records fall outside given service level...

I used the -S flag for the BCP command to specify the servername. Once again, we only have one server and it worked just days ago, but that does appear...

A change log? Hahahaha... That's a good one.

Well, I figured it out. I had to add the -S flag and specify the server. Don't ask me why... it worked 3...

I was removed from the system administrator group. I figured this out a few minutes ago. I was able to fix the Agent problem from the server. People at my...