chris.asaipillai-624309 (10/2/2016)

---

Thanks guys for that.it worked.

OK if I need to extract another item from that pice of xml then do I write this folowing

SELECT

SX.OldRow.value('(Airline/@lastUpdatedByUserID)[1]','INT') AS lastUpdatedByUserID,

...

komal145 (9/30/2016)

---

I have a table with dates

date Sends Opens ...

Quick thought, I wouldn't expect the optimizer to do anything but abort the optimizing process on a time out when handling queries with hundreds of apply operators.

😎

Several ways of doing this, here is one fairly straight forward method

😎

Note: added few entries to the sample data.

USE TEEST;

GO

SET NOCOUNT ON;

--- Query parameters

DECLARE @ITEM ...

I know I'm splitting hairs but there are quite some differences between the different methods of producing inline tally or number sequences. The method DesNorton posted is quite efficient but...

Deadline

Good job!!

😎

Sean Lange (9/30/2016)

---

Eirikur Eiriksson (9/29/2016)

---

As Sean rightly mentioned, there are many ways of parsing and extracting values from an XML. Many of those methods are similar in syntax but may...

My take on this would be to separate the current status and the status history as those are two different things and should not be combined in a model entity.

😎

Current...

As Sean rightly mentioned, there are many ways of parsing and extracting values from an XML. Many of those methods are similar in syntax but may vary hugely in performance....

BLOB_EATER (9/29/2016)

---

so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

You are very welcome Rodney!

😎

rodjkidd (9/28/2016)

---

Many thanks.

Let me know if you want the 13 person one uploaded. As the additional extras are all over the place in that one! But going to take a...

Hi Thomas,

from what I can see at the first glance is that the First_Value function does not have a POC (Partition, Order, Covering) index to work on and the cardinality...

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#LookUp') IS NOT NULL DROP TABLE #LookUp;

CREATE TABLE #LookUp (Loc int, EmpID int)

INSERT INTO #LookUp

VALUES (1,123)

,(1,222)

...