Hi Gail,

I am struggling to make it where to put like operator and where to put '%' at the end

update t1 set name = T2.searchname from @T1 T1...

Hi Gail,

Thanks for the reply and can you please edit my sample update query as per your advice to help me on understanding please

Hi Sean,

Thanks for your reply and jsut now i finished my requirement with rownumber as like your logic. I thought of doing it without the rownumber logic. Finally I end...

Oops. I totally forgot that. Thanks for reminding me Luis...

Sorry Jeff for the confusion.

Hi Jeff,

I would be using this against real table and not temp table. just to play with test data i gave temp variable and data on my sample. Still...

Hi Jeff,

Thanks for your reply and basically i am planning to create generic function which will take "table name","column name to makecomma separated" and "where condition" and send the...

Great, i am looking for this only. i had this in my mind but didn't know i can create like this.

Thanks Luiz for confirming. appreciated.

Yes, i know the number columns in the output always.

thanks

Thanks Eirik for the straightforward method. Appreciated.

Hi Jeff and Scott thanks a lot for great explanations and i learned good lesson from your replies. I would like to through a point that all these tables are...

Hi Jeff,

Thanks you so much for your elaborated explanation and really helpful for me to move forward. I am in the position to explain few other points,

Regarding the point #1...

Thanks Jeff and i will wait for your workaround. Sorry for disturbing on the weekend......

Hi Jeff,

Please find my answers to your questions,

1. Does the #TestDataDump table represent all new data or is this maintained in a real table that you keep adding to? If...

Hi Scott thanks for the reply.

Hi Jeff , thanks for the reply and yes, the dump table has 3 million same kind of data. I also mentioned in my...

thanks Jeff and that is my next action item. Right now am closing this thread. If something goes wrong, i will open it again for the discussion.