Thank you for the query.. 🙂

Ok..a friend of mine found the solution 🙂

Just replace this in the query

./column[@name=

SELECT *

FROM OPENXML(@hDoc, '/resultset/row',2)

WITH

(

AccPrimaryId varchar(30) './column[@name="AccPrimaryId"]',

AccountId ...

Thank you.. I appreciate it. 🙂

CREATE TABLE [dbo].[DBA_Codes_Result](

[RESPrimaryId] [nvarchar](255) NULL,

[ResultCode] [smallint] NULL,

[Description] [nvarchar](25) NULL,

[Abbreviation] [nvarchar](7) NULL,

[Notes] [nvarchar](250) NULL,

[LastUpdateTime] [datetime] NULL,

[LastUpdateUser] [nvarchar](60) NULL,

[CreatedTime] [datetime] NULL,

[CreatedUser] [nvarchar](60) NULL

) ON [PRIMARY]

I am not sure what you mean by ddl forthe target table. 🙁

I'm sorry about the confusion.

I was trying to extract the data(individual values) from the HTML to a Sql table.

Thank you once again on the feedback.

🙂

Is it possible to attach a screen shot of the folder(set the view to details so that we can see the name,date modified, type, size

and also the path/location where your...

Thank you Dhasian you have showed me a new approach to fix this issue (I thought that Pivot is the only way)

I appreciate your help 🙂

Also I have an additional...

cool it worked like a charm.. 🙂

Hi Sean thank you for the reply. I really appreciate the help.

I have one issue with the result.. Mytype C3 has to have its results group into one.. like

MyProcMySeqMyType

11a1

11this...

Hi ChrisM@Work thank you for the reply.. I have one question in case they are more than 100 quanties what do I need to do.

Thanks Jeff Moden for the article

I have learned something new.. thanks to you mickyT.. 🙂

I have no clue how this works.. :blink:

Pls could u break it down as to how can i use it