SQL Kiwi (1/15/2012)

---

The error about the engine not being able to obtain a LOCK resource is a consequence of a server with a small amount of configured memory, and an...

Sample data for testing:

DROP TABLE Table_1

CREATE TABLE Table_1(

RowID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED,

custid INT,

store VARCHAR(9) NOT NULL,

amount INT)

INSERT INTO Table_1 (custid, store, amount) -- 2 million...

martin.david (1/15/2012)

---

Hi,

i'm sorry, maybe i'm using wrong word for my problem..

sequence that i mean is same transaction that...

How many distinct stores are there in each table?

Hi Martin

By "sequence in data" - do you mean sequence by ID?

Cheers

SQL Kiwi (1/14/2012)

---

ChrisM@home (1/14/2012)

---

Paul, have you compared the performance of this method against a rCTE yet? I must admit I should have but haven't taken the time out to do...

Paul, have you compared the performance of this method against a rCTE yet? I must admit I should have but haven't taken the time out to do it. If I...

SQL Kiwi (1/14/2012)

---

No, I just ran:

UPDATE STATISTICS dbo.Table_1

WITH...

Thanks Paul - looks like it's time to revisit Gail's NOT EXISTS vs etc blog 😉

Edit: you've got a 700 million row sample data set on your home lappy? Good...

In the meantime, you will get some mileage from this

SELECT custid, store, Amount

FROM Table_1 t1

WHERE NOT EXISTS (SELECT 1 FROM table_2 t2 WHERE t2.store = t1.store AND t2.product !=...

Ten seconds ain't so bad.

Can...

Blimey! First post, and you've set up a ton of sample data! Top work!

I think this is what you're looking for:

SELECT

Date,

Price,

AskClient,

Dupes = COUNT(*)

FROM #trading

GROUP BY...

bicky1980 (1/13/2012)

---

...

Thanks for the reply, if there were 2 duplicate datakeys with different landline values, I would only want this to be counted as one record, as I dont want...

bicky1980 (1/13/2012)

---

Total number of populated Landline fields (Needs to have a unique datakey as well as be unique itself - If the same landline is anywhere else in the ...

Hi Bicky

Some very experienced and talented folks are having real difficulty figuring out exactly what you want here, and it looks to me that you might still be figuring it...