Good point... In this case, the query that creates the @table is a summarizaton so uniqueness will be there... Thanks...

Thanks... used a table variable and it works great! Appreciate the help.

Thanks, but I need the item# number returned also...

Thanks - seems so obvious now... 

Just an ad-hoc query on small amount of data, so used the round - easiest to implement and not really concerned about performance...

Thanks again!

Thanks again... 

Thanks...  I'm not crazy about the fact that we have to update this constraint if we add any new status id's, but this works now, so we'll give it a try! ...