Thank you Brian Gale for your reply, my clarification is about ldap.ora because Oracle Connector is working only with tnsnames.ora. we use Service account to access the oracle database to...

Thanks for the snippet Spiff, after given the complete image url i got favicon displayed in the local machine. If it's didn't works after deployed to server I will try...

Yeah, Finally I got the Links b/w the tables and the corresponding snapshot.

Thanks a lot Sean Lange for your guidance, I planning to do some code changes in the product to log the proper logs into this table.

Thanks Once Again.

Thanks Sean,

Business of the output is to find the number of request per LocID, avg time taken per request, min time taken & max time taken.

Combination of 1 PS &...

Thanks Sean,

The result will be looks like as below,

LocIDClientCertificationMsgType Time Taken

NOT SPECIFIED QRY_T12 10 Sec

759NOT SPECIFIED ...

Thanks a lot Alvin Ramard & Lowell for your kind guidance, find the root cause issue it's because of one environment saving the date in UTC timing due to that...

Thanks a lot Shawn Melton & happycat59 for guiding me.

Sorry mister.magoo, somehow i missed to hit the post reply button, i need to read all the child node of EVN_EventType. Thanks much.

Please find the sample data,

DECLARE @tmpTbl TABLE

(

ID int,

BodySegment xml

)

INSERT INTO @tmpTbl (ID,BodySegment) VALUES

(1,'<ns0:ADT_A03_26_GLO_DEF xmlns:ns0="http://microsoft.com/HealthCare/HL7/2X">

<EVN_EventType>

<EVN_1_EventTypeCode>A03</EVN_1_EventTypeCode>

<EVN_2_RecordedDateTime>19000101144602</EVN_2_RecordedDateTime>

...

Thanks mister.magoo for your post suggestion, I will correct it and share the updated content shortly.

Thanks mister.magoo, please find the sample XML structure for 2 records in the table,I'm trying to read those nodes value in select clause.

Record 1

<ns0:ADT_A03_26_GLO_DEF xmlns:ns0="http://microsoft.com/HealthCare/HL7/2X">

<EVN_EventType>

...

Thanks for your reply, the value int the parent node "ADT_A03_26_GLO_DEF" will vary for each and every record.

Thanks Guy. I came up with my own solution by replacing those content with my custom string by using the string replace function.

It will more helpful if you share the...

Thanks a lot Doug.Brown & Joie Andrew, I Fixed this issue by going through log file.

Root Cause : I have missed the "GO" between my SP Script & GRANT...