Hi Again,

Ok, here it is, the sample code i gave you was a mini replication of what i need to do, the field names and stuff are diffrent but i...

Thanks for your help Flo, i am now trying to apply this with the actual structure here, fingers crossed but i already have a head full of questions so keep...

Is this ok, the data example is quite simple as it would only be in the source table, then from there the query will push that data into the destination...

Hi,

Ok, it's not that straight forward or easy to explain so i have taken a few fields just to get a proof of concept. So the wce_contact table is...

Thanks for your replies. In answer to your questions see below:

* Are the 4 (source + 3 destinations) same structure?

--The destination tables have the same field names.

* Could you please...

Great, thank you both for that. I have it working with both the if statement and case, i wanted to try them both so i learn more. Great...

Thanks for your help, i found the issue it was a silly one, the arguments hadn't saved so it was passing two not one.

Chris you taught me two...

I am only passing the activityid. The rest i am selecting from the activity table inside the procedure.