Viewing 15 posts - 1 through 15 (of 30 total)
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...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
May 11, 2016 at 1:21 pm
Yeah, Finally I got the Links b/w the tables and the corresponding snapshot.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
January 27, 2016 at 10:08 am
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.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
November 9, 2015 at 8:24 am
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 &...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
November 6, 2015 at 1:21 pm
Thanks Sean,
The result will be looks like as below,
LocIDClientCertificationMsgType Time Taken
NOT SPECIFIED QRY_T12 10 Sec
759NOT SPECIFIED ...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
November 6, 2015 at 12:16 pm
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...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
September 18, 2015 at 8:51 am
Thanks a lot Shawn Melton & happycat59 for guiding me.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
September 14, 2015 at 7:32 am
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.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 6, 2015 at 9:41 am
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>
...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 5, 2015 at 9:28 am
Thanks mister.magoo for your post suggestion, I will correct it and share the updated content shortly.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 5, 2015 at 9:18 am
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>
...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 5, 2015 at 9:09 am
Thanks for your reply, the value int the parent node "ADT_A03_26_GLO_DEF" will vary for each and every record.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 4, 2015 at 2:01 pm
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...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
August 3, 2015 at 1:06 pm
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...
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
June 23, 2015 at 3:00 pm
Thanks Doug.Brown, But I'm using NOLOCK in my select query.
___
Known Is An Drop,Unknown Is An Ocean....
Njoy Programming 🙂
June 22, 2015 at 12:14 pm
Viewing 15 posts - 1 through 15 (of 30 total)