thank you. yes, this worked. appreciated

thanks a lot scott. it helped me

sorry for being late in responding. i will mark it as answered this thread as i got answers from jeff and jonathan.

Hi Jeff,

thanks a lot for the code snippet  and table structure. i learnt from this. you have mentioned that i don't need the transaction for this scenario. I would like...

Hi Jeff,

as you mentioned in the previous thread, you came across this situation and you have solved this issue in different way. would you be able to pitch...

Thank you Jonathan for the script. Scott mentioned about sp_getapplock. shouldn't we considered those advice. again, i am bringing this point to make the perfect solution. i gone through the...

thanks for the explanation scott and i would request to give me the sample script to achieve this scenario.

Thanks a lot Jeff and Scott for the reply. i would request  to provide some same script to achieve this. this will help me to learn as well. so please...

Thanks a lot scott.

Thanks a lot lynn and Chris. much appreciated

thanks a lot guys for making me to understand the logic behind.

Hi pietlinden,
It's a ClientProductdescription and the record might go more than 4000 character. that's why kept as max.

can anyone please assist me

Hi Scott, Thank you for the reply and i need more input from you.  Actually i need ActiveStatus because the table will have Inactive clientproducts as well. So, if you...

thank you luis. new learning for me