I thought that might be the case;-)

Here is an adjustment to the code, picks the two last entries for each subject

😎

create table #temp(candId int identity(1,1),CanNum int,name varchar(50),Attempt1 int,Attempt2 int,attempt3...

Quick suggestion, use the nodes method, check out this example

😎

DECLARE @TXML XML = '<?xml version="1.0"?>

<SEARCHREQUESTRESULT>

<DOCUMENTS>

<DOCUMENTDETAIL>

<DOCUMENTDATE />

<CONSIDERATIONAMOUNT>0</CONSIDERATIONAMOUNT>

<BOOK><![CDATA[]]></BOOK>

<PAGE><![CDATA[]]></PAGE>

<REFERENCENUMBER><![CDATA[]]></REFERENCENUMBER>

<NOTES><![CDATA[]]></NOTES>

<RETURNEDTO/>

<PARTIES>

<PARTY>

<ID>1090</ID>

...

Andrew Kernodle (9/19/2014)

---

My company would certainly benefit from upgrading to 2014 at this point; not so much because of new features (though in-memory could potentially be useful for one table...

Quick thought and as g.britton pointed out, the reference has to be exact, try this out for a size

😎

DECLARE @testXml XML;

select @testXml='<invoices>

<InvoiceNo>13537010*1</InvoiceNo>

<psship>value_psship1</psship>

<InvoiceNo>13537010*3</InvoiceNo>

<psship>value_psship2</psship>

<InvoiceNo>13537010*4</InvoiceNo>

<psship>value_psship3</psship>

<InvoiceNo>13537010*5</InvoiceNo>

<psship>value_psship4</psship>

<InvoiceNo>13537010*7</InvoiceNo>

<psship>value_psship5</psship>

</invoices>';

SELECT

INVOICE.DATA.value('.[1]','VARCHAR(50)')

FROM @testXml.nodes('/invoices')...

Quick first questions, what are the server specs, has the behaviour been trending, what is the maxdop, the threshold for parallelism, server version/edition?

😎

wolfkillj (9/19/2014)

---

okbangas (9/19/2014)

---

I have some doubt on the correctness of this question. As you get the coordinates from a GPS system and your task is to store the coordinates (calculation...

Breaks my heart seeing such an opportunity waisted!

😎

Stewart "Arturius" Campbell (9/19/2014)

---

TomThomson (9/19/2014)

---

Good question.

I was feeling too depressed by my nation's decision to stay under England's domination :crying: to do any research this morning, so I took a...

pawana.paul (9/19/2014)

---

Hello,

I altered index with maxdop to somevalue (n). What is the query to validate that xyz index has maxdop value set to (n)?

I tried with GUI. index properties, option...

As far as I've seen, the retention issues are not the platform itself but the dependants. The technical part of the SQL Server upgrade is one of the smoothest there...

Not certain what you are indeed asking but a short list...

There are few ways of doing this, here are two of them. The first uses a combination of GROUP BY and HAVING, the second uses ROW_NUMBER and MIN/MAX Window function.

😎

USE...

Here is a suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

CallStartDateTime DATE ...

Luis Cazares (9/18/2014)

---

I tested it on sqlfiddle.com and...

Oops, used the wrong code:-P Here is the correct version, in fact the same thing Luis posted, but in SQLite dialect

😎

select

1 AS Group_ID

...