N_Muller (11/20/2014)

---

As far as I know there are two ways of reading XML using SQL, either openxml or XQuery. There's a lot of debate on which is better or...

Quick thought, this doesn't look right...

Multiple "Secure/SecureType" elements will multiply the outer/parent "SecureEvent" element, as this is...

Koen Verbeeck (11/20/2014)

---

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable me):

http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp

Note that you...

N_Muller (11/20/2014)

---

I have a table with an indexed XML column. Is it possible to use openxml that takes advantage of the indexes in the table? To my knowledge, openxml only...

Quick thought, if this type of queries are frequent, consider adding a geography column to the tables.

😎

Here is a far more efficient way of producing the same results

USE tempdb;

GO

SET NOCOUNT...

jasona.work (11/19/2014)

---

Well, this is shaping up to be an interesting winter here in North America...

Not even the end of November, and already we've got here in Detroit, Michigan, about 1/2"...

Quick cross-tab suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA (ColumnA,ColumnB) AS

(

SELECT 1 AS ColumnA,88 AS ColumnB UNION ALL

SELECT 2, 99 UNION ALL

...

Quick solution which uses a recursive CTE, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML =

'<SecureEvent EDate="08/04/2011" ID="47854303" InternalSecureEventID="154472406">

<SecureEventDate>08/04/2011</SecureEventDate>

<TimestampCreate>08/04/2011...

nikki123 (11/18/2014)

---

how do i get through the diag codes was working like this but shows null value

SELECT

HEADER.DATA.value('@CLM_ID', 'NVARCHAR(max)') AS CODE,

LINE.DATA.value('@CLM_ID','NVARCHAR(MAX)') AS CLM_IDLine,

DIAG.DATA.value('@DX_code','NVARCHAR(MAX)') as DX

FROM ...

serg-52 (11/18/2014)

---

kriskumark96 (11/17/2014)

---

Hi,

The three queries is of the same tables with different where condition are used , so that we cannot have a join or cross join on it

Or

Is there...

Evil Kraig F (11/17/2014)

---

Okay, you...

There is nothing...

Evil Kraig F (11/17/2014)

---

Yes, I did. Still have the old version. Nothing there, single declaration.

Ah, that. The chioces are User:: and System::. Why would I wan't to...

nikki123 (11/17/2014)

---

Hi

Got an other issue how do i get to the node Line , use d a OUTERAPPLY but the data is showing null

SELECT

x.item.value('@CLM_ID', 'NVARCHAR(max)') AS CODE,

g.line.value('@CLM_ID','NVARCHAR(MAX)') as...