bopeavy,

Thanks for looking this over and responding!

After some testing, we decided to go with a stored procedure that runs a query to find the documents as well as using an...

I do like the idea of removing the cursor. Either an update as already suggested or the SQLServerName column could be changed to use a default:

[SQLServerName] [nvarchar](150) NULL DEFAULT...

Ahh, that makes sense. In this case, that is okay (phew!). Thank you for the follow up explanation.

Oops, sorry for the confusion! Yes, I think your solution is much, much better than my original thought and I am using it. All I changed was for the script...

I modified it to look at months and it worked perfectly! Thank you so much to both of you!

So much simpler than where I was headed.

Here's the script I am...

Hey Steve!

I have found your site to be very helpful and always sign up wherever I work. Thank you!

Okay, so my bad syntax...

I am trying to put the database name...