I need to essentially stack one View from management studio onto another, but without any duplicates. I’ve looked at my options but have no idea with what is right. Help!
Without seeing a schema…I’ll ask if you have you looked into
UNION ALL ? It doesn’t remove duplicates.