One method to be able to vary any item in a select statement is to use a string method to create the statement and then execute the string .. e.g....

Obviously a host of ways, but the simplest method, and easiest to debug, would be to create 6 select statements, with WHERE clauses - one for each type, and Union...

Good explanation, I can understand now why the issue cannot be resolved up front.

Thanks,

I do wonder how you came to use the UNION ALL statement when looking at inserts in this case. What drove that thought of enquiry, as such statements are not...

I have had a similar problem in the past, but rather than looking to clean up after the fact, I test for duplicates beforehand and eliminate the insert at that...