ahh...

I could figured out the logic around. Below is the try for my another question and it works fine

...

Hi Jeff,

All your concerns are very valid and Regarding table name, age datatype, ID are just sample structure to play with data on this thread. As i said in my...

since this is research i am doing it, next i am going to try with dumping the data as it it with Bulk insert and will be using DelimtSplit8k function...

Hi Jeff,

thanks for your time on this and what i did was i just added line feed for the last row and am able to achieve without any errors....

Hi Jeff,

Thank you

yes, the end of character will be CRLF (carriage return line feed). also i tried with second option which was mentioned in my samplescripts attachment in my previous...

Please find the attached files for the reference and please let me know if i need to provide any additional info.

thank you for your precious time.

Hi Jeff,

Thanks for the reply and really am little confused about which five lines you are asking for. The sample data i posted has typical structure of my actual data...

Hi Jeff,

thank you so much for your precious time on this post. Here is my try as per your advise,

I learned how to generate test data from you a year...

Hi Jeff,

Thanks for your response and really it's helpful. I did try with Bulk insert and it's very fast.unbelievable. it just took 6 seconds for half million records. So i...

Hi Jeff,

Here is my work,

I have a folder called "FTPFiles" which used get files in my application server. File incoming occurrence will be daily/ every three days/ Weekly. But we...

Hi Jeff,

thanks for the reply. I have another idea. How about writing c# code to read the text file and dump it in intermediate table with the way it is...

Hi Jeff, thanks you so much for your reply

I will need to import that too. all the fields needs to be imported. Updated my sample table structure. Please help...

Hi Luis,

Thanks for the link and I created CTE on top of Eirik query and get the output as i needed.

thanks Eirik for the base logic.

Hi piet,

Thanks and union all with few additional condition did the trick

Hi Eirik,

Thanks and Could you please help me on understanding why do need to use xmlpath for this...

Thank you Wayne.