Hi - I have a similar issue to the one discussed here. Wasn't sure if I should create a new thread or not, first I'll try reviving this one.

I also have a situation where my source data has multiple rows - but the behavior I would like to happen is that my target rows get expanded - i.e. rows get inserted for each duplicate.

I basically want it to be have the same behavior as if I was joining the two tables together.

For anyone interested - here is my use case:

My target table is data which originates from a feed we download from an external source. My source data is a table that we control. There is a common identifier in both tables and I am trying to populate IDs and other data from our table into the target table. The thing is, in our source table it is a valid scenario that there could be multiple records with the same identifier. Specifically, some of those records may be "active" and others "inactive" and we need to see all. If my target table has one record that matches 3 records in the source table, I want to end up with 3 records in my target.

Is there a way this can be accomplished using a merge? I can think of other ways to do it, like joining and inserting into a new table, etc. but I'm hoping there is a slicker way to do it - maybe using MERGE.

Thanks,

H