where RegionName = @Region
Where the split up region name is the same as the original concatenated list? Don't think that's quite what you want....
How are the split up region and queue names supposed to be related to the work_items table?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability