No worries mate - so long as you keep up the repayments! 😛

A completely different method, courtesy of Dwain C:

;WITH SourceNums AS (

SELECT strcol FROM (VALUES ('1'),('2'),('5'),('7'),('8'),('9')) a (strcol)

),

nTuples (n, Tuples) AS (

SELECT 1, CAST(strcol AS...

Eugene Elutin (9/12/2012)

---

I've tried all three methods, INNER JOINs, CROSS APPLY and CROSS JOIN with WHERE: all produce very similar query plans with use of Nested Loops (Inner Join).

Cannot...

GSquared (9/12/2012)

---

Here's what I came up with. Does the same thing the same way, just another way to write it:

WITH Numbers

...

There's something screwy about this - you're aggregating on pr_id but expecting the max date per id. Try isolating the part which generates data for TBL_VAL and working with it...

Anju Renjith (9/12/2012)

---

Step:1

CREATE TABLE tbl_Group_Test

(

_ID INT IDENTITY,

_Place VARCHAR(50),

_Name VARCHAR(100)

)

Step:2

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Abdul Kalam')

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Karunanidhi')

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Jayalalitha')

INSERT INTO tbl_Group_Test VALUES('Tamil Nadu','Robin Singh')

INSERT INTO tbl_Group_Test...

ChrisM@home (9/11/2012)

---

...

If there's no index on it, then that's your problem. Each delete in SPTLog will cause a table scan of the column in SPTLogArchive to ensure that the key...

venus.pvr (9/11/2012)

---

ChrisM,

No two columns should have same value within a row. With the query you provided, below is the result set:

111

222

123

124

567

8910

3NULLNULL

First two rows have same values for all the columns.

Thank...

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

oscarooko (9/11/2012)

---

It actually took me 47 minute to delete 13 684 records in batches of 100. I am there's got to be a faster way, and one...

oscarooko (9/11/2012)

---

It actually took me 47 minute to delete 13 684 records in batches of 100. I am there's got to be a faster way, and one of you good...

SELECT

col1 = MAX(CASE WHEN seq = 1 THEN a END),

col2 = MAX(CASE WHEN seq = 2 THEN a END),

col3 = MAX(CASE WHEN seq = 3 THEN...

oscarooko (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

oscarooko (9/11/2012)

---

I am trying to delete old records from a table, and insert them into another table. Problem is that it is...

Lynn Pettis (9/11/2012)

---

ChrisM@Work (9/11/2012)

---

oscarooko (9/11/2012)

---

I am trying to delete old records from a table, and insert them into another table. Problem is that it is taking too long. The...

oscarooko (9/11/2012)

---

I am trying to delete old records from a table, and insert them into another table. Problem is that it is taking too long. The table has about...

Brandie Tarvin (9/11/2012)

---

Forgive me a moment, Eugene, while I poo-poo your...