select Job, COUNT(job), ---RTRIM(LTRIM(TagNumber))as tagno,
case when i.TagNumber between 1000 and 3999 then 'Charlestown'
	 when i.TagNumber between 4000 and 4099 then 'Toolroom'
	 when i.TagNumber between 4100 and 4124 then 'Plating'
	 when i.TagNumber between 4125 and 4199 then 'Diamond Turning'
	 when i.TagNumber between 4200 and 4244 then 'Flycut'
	 when i.TagNumber between 4245 and 4319 then 'Coating'
	 when i.TagNumber between 4320 and 4359 then 'Post Polish'
	 when i.TagNumber between 4360 and 4534 then 'QA'
	 when i.TagNumber between 4535 and 4549 then 'Nitrogen Cabinet'
	 when i.TagNumber between 4550 and 4659 then 'Refractive'
	 when i.TagNumber between 4650 and 4659 then 'Shipping'
	 when i.TagNumber between 4660 and 4759 then 'RMR'
	 when i.TagNumber between 4760 and 4769 then 'Assembly'
	 when i.TagNumber between 4770 and 4819 then 'Misc'
	 when i.TagNumber between 4820 and 4850 then 'Wip'
	 when i.TagNumber between 4851 and 4875 then 'Coating'
	 when i.TagNumber between 6000 and 6499 then 'Vendors'
	 when i.TagNumber between 82008 and 83999 then 'Keene'	 
else 'Unknown'
end tag_loc
from InventoryWipTags i
group by job,TagNumber
having COUNT(job)>1
order by job