Thank you so very much for such a great idea. I used to use #tmp tables all the time, but haven't in a while and didn't even consider it.

The...

I just re-copied your sp and it is working like a charm. For the life of I don't know what I did to mess it up.

The code does confuse...

Thanks MM. It's working in some ways but not in others.

If I have things in priority 1, 2, 3, 4 and I move Priority 3 to 2,...

Thank you so much for taking the time to reply and pointing me into the direction of the boards etiquette. It was very helpful.

There can only be one work...

I should have given more detail on my original posting, at the very least some code to show I am trying. I wish I had. Hopefully this will...

Figured it out.

Open Enterprise Manager, Right Click on the SQL Server Group. "Edit SQL Server Registration Properties..."

.... Why, why, why didn't I think of it before. Back to...