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...

Evil Kraig F (11/17/2014)

---

Eirikur Eiriksson (11/17/2014)

---

Quick suggestions, open the package in a text editor and search for the variable name, there should only be one deceleration with that name but...

Quick suggestions, open the package in a text editor and search for the variable name, there should only be one deceleration with that name but you might find another with...

Quick thought, don't use the traversing // if the position of the element is known, far more expensive than the direct reference.

😎

SELECT

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

FROM @x.nodes('CLAIM/INPUT/HEADER') AS x(item)

That kind of summarizes it doesn't it? If there was an...

I should have mentioned DelimitedSplit8K[/url], it's perfect for the job.

😎

Then my suggestion is to check out EasySoft's odbc driver

😎

Guess you are on RHEL 6 given your kernel version;-), check this out "Microsoft ODBC Driver 11 for SQL Server on Linux"

😎