OK, thanks for your input!

ah, sorry, forgot about sorting, to get the numbers to sort right would have to use an extra space in front of the 0-5 and 6-10:

SELECT...

if you just want a row for each group, you need to calculate the ranges into a new column, maybe something like this:

SELECT dr.DaysRange, COUNT(*) AS...

I'm thinking your day ranges probably shouldn't overlap, so I'm assuming you mean 0-5, 6-10, 11-15, > 15

SELECT
   

OK, in your SQL Agent job on ServerA, you can have a step of type "Operating System (CmdExec)" that calls SQLCMD with the -i parameter to read the script that...

edit:  oops this idea doesn't work... still coming up with other ideas

Maybe it would be easier to store the dynamic SQL statement into a table on server B instead of a file?  Just thinking it's easier to avoid the external file...

it may make more sense to rename the current column, create the new identity column, set the IDENTITY_INSERT On for the table, UPDATE the new identity column from the renamed...

Some other things to consider:
-  are there any SQL Agent jobs?  You can script those out from the Object Explorer Detail window.
-  are there any linked servers?  You...

I'd recommend against using the preparedocument method of shredding XML, this is the old SQL Server 2000 way of doing it and is memory and resource intensive.  You can use...