Hi Jason,

Thanks for your reply. Can you tell me how to write my connection string in web.config?...

I also just changed the owner to sa, it returns same 0 to all number - that's not right.

Good catch!

However, I checked the owner of the job in the maintenance plan, it is me and it's dbo and it has access to the fn.

Thanks for quick response.

the sp will calculate correct number and insert them into the table Summary.

I don't have any problem running the sp outside the maintenance plan.

Thank you all guys, it does help so much when you leave it for a while and come back and see it is fixed.

Thank you guys.

Don't know...

Thanks for your reply. Question a was answered already, example was given in the post, and here again for your convenience:

DECLARE @Data XML;

SET @Data =

'

14

2260586.523

0.018

';

SELECT @Data.value('(/*/Result/EngineInfo/ModelDataVersion)[1]', 'NVARCHAR(10)') ModelDataVersion;

For question c: this function is only used by me, so I wouldnot query a non-existing node.

I already answered your question. Thanks.

Thanks for replying.

I didn't know the original data was modified automatically by the system, with the IFCode markup, the data should be:

keyword1.xxx

value1

keyword2.yyy

value2

keyword3.aaa

value3

keyword4.bbb

value4

....

There are some other solutions but they are all...

Thanks. The link gives error:

The specified request cannot be executed from current Application Pool

This is all explained in the article, but it's actually easier for you to format it correctly as we requested (there's a tool for it)

than it is for me...

Hi Barry,

I already attached my data in the previous post, I am sure you can easily import the two tables into your sql server.

Thanks again for your help.

P.S. The result...

Hi Barry,

I would rather wait until you test it, the code hangs there, for more than half an hour, got to be something wrong.