Thanks a lot it worked like a charm. You are a champ.

😀

hello All,

I have been doing that from Table A in excel using tranpose function, trying to find a way on how to do that using t-sql.

Thanks in Advace.

Sharon.

hi,

You are a star it worked like a charm, thanks for your time.

-Shilpa.

Thanks for your suggestion the "stuff" worked like a charm. You are a star

Thanks for your suggestion the "stuff" worked like a charm.

hi Rodak,

Sorry i was not clear in my response. We store company and person details seperately in company (columns : name, address, street, city, state, postcode, country, dx, phone, fax)...

hi Rodak,

Thanks for your suggestion. I have listed the structure of data in Excel file but the same data is stored in two different tables in the database tlbcompany, tblperson.

I...

hi Chirag,

Thanks for your advice i have used that. I really appreciate your time.

Thanks, Shilpa.

hi,

Sorry for the late reply and i really appreciate your time and advice. I have done as adviced and it worked. The database on my laptop is testing database which...

hi All,

Thanks a million for your time and suggestions. I have taken the advice of Gianluca and included the t-sql code to capcure the audit information in the existing AFTER...