Thanks Johan, Unfortunately, the eXtended Events did not captured the query that I ran. I tried looking for my query syntax on the DBA_LongRunningQueries.xel but to no avail. These are...

Thank you it works.

last question. I tried to make it an update statement but got an error below. Any ideas how to fix this?

Thanks

Update T = T.col3 + ISNULL(LEAD(col1) OVER(PARTITION BY T.DocName ORDER...

Jonathan,

Actually your code works. I did not mention there is another parent row and when I exclude the parent row it works. Thanks so much for your help.

Jonathan,

Please see my data below. Also in the attachment with pipe delimited.

I meant your code did not return any errors but the output result is the same where I am before below

Plucked in your new code. I am still getting the same result.

Jonathan,

You code works for hardcoded values. I replaced the Values with my #Temp1 table. I am getting an error. Any ideas?

SELECT T.Id, T.DocName, T.col1, T.col2,

T.col3 +ISNULL(LEAD(col1) OVER (PARTITION BY T.DocName...

Hi Jonathan,

Thanks for your input but your code will not work for me. This is because the I have thousand of files that I am importing. Thus hard coded the...

Thanks Erland.

My thought is to import the Word and PDF into a string vardinary(max)  or  nvarchar(max) data type and run data iteration trim and replace and insert into the allocated table...

Hi Erland,

I like to give an example with the link below under the section "CURRENT ASSET LINK" supposed to be a Word document. How can I parse the data First...

Thank you Erland for your advice. I have not picked up the project yet but this is the first time I heard people who use Java script to import word...

Thanks for your response. The purpose of the word document import into SQL server is to parse the data into a table and export into excel. The current framework was...

That is correct. I want to store the content of the Word and PDF in vardinary into SQL server. Also, If can do some parsing using Java script as well....