Hi Jeff,

your sample data format is perfect. This is how my data will looks like. Do you have any solutions.....

Oh that's my bad and sorry Gila.

Thank you Jeff for the information. also answer for your question on Table2 we will have duplicate product name as it contains comma...

Thanks Jeff and Gila for the reply. I totally agree your answers. Appreciate gentle men.

Hi Mark,

Thanks a lot for the cross Apply option.

Well, Thanks for your response and useful query.

my ultimate question is can we have multiple insert statements inside merge clause? if yes can you please show some sample how to achieve this requirement

your example showing how to...

Agreed and thanks for your response

Opps!! i didn't see the link you posted. Now i read the blog and finally for my requirement i am opt to use Not Exists as i have Null in...

Thank you Gila.

i am done with my requirement using below three concepts.

1. using Not In

2. Using Left Join

3.Using Not Exists.

Which one is the best choice to...

Dear Jeff,

Thanks for your time on this and it will be more helpful if you have much better choice than my approach as it is function.

Here is the code i tried and works fine the only minute draback of using this function take few milliseconds delay than using the sql query. but writing function uses...

I am done with writing function to remove the special characters and number from string.

Thanks everyone who responded to my question.

Thank you for the reply and will post the output soon.

thanks a lot gentle man.

hi friends thanks for ur cute replies