Sean Lange (5/13/2014)

---

rhythmk (5/13/2014)

---

With the help of Eirikur Eiriksson's code.You acn try this.

;WITH test

AS

(SELECT POLICY_DETAILS_ID,HISTORY_ID,CODE_ID,

ROW_NUMBER() OVER(PARTITION BY POLICY_DETAILS_ID,HISTORY_ID ORDER BY code_id) AS rn

FROM @POLHIST)

SELECT POLICY_DETAILS_ID,HISTORY_ID,

MAX(CASE WHEN rn = 1...

:-DNice MM

😎

Quick solution

😎

Use tempdb;

GO

DECLARE @CUST_PAY TABLE

(

CustNO INT NOT NULL

,InvNO INT NOT NULL

,ChkNO INT NOT NULL

);

INSERT INTO...

dndaughtery (5/12/2014)

---

I agree, I enabled as many tranformations as possible to run in parallel and removed a lot of merge joins, sorts and just did a join in the oledb...

A lot and some, seriously the more the merrier.

😎

Apart from straining the neck:hehe:, not really, most who I have...

Lynn Pettis (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

ChrisM@Work (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

Mike Saunders NL (5/12/2014)

---

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not mentioned. Is...

ChrisM@Work (5/12/2014)

---

Eirikur Eiriksson (5/12/2014)

---

Mike Saunders NL (5/12/2014)

---

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not mentioned. Is there a way to...

The POC index...

Mike Saunders NL (5/12/2014)

---

Hi, this works! Thanks

The only thing that is missing is that the days with no events are not mentioned. Is there a way to display these days...

Good stuff!

I had forgotten about this,...

Here is a simpler window function (2012/2014) version. Although simpler than the earlier 12/14 one, it performs similar, mainly because of an sort operator which is around 60% of the...

Bill Talada (5/12/2014)

---

Here is some further information: I ran the script above on a different server and it ran in a second vs. 30 seconds on mine. Both servers...

paul 31908 (5/12/2014)

---

Hi all,

I am creating a database where each record is required to have a twin record in the database.

These is a type a value and a type b...

Good question, thanks!

😎