thats great! works like a charm.

It looks like this solution would work, unfortunately we do not have the enterprise edition of sql server. Is there another way of doing this? We are using the standard...

That sounds like a solid solution. I'll try to implement it today. Thank you

edit: works.