The thread starter was not Bob Cullen (the chap playing around with an alternative solution...

Tom Brown (1/12/2012)

---

And some important missing data. CODE now has a unique index, It was one of those 'assumed' "things the application could never let duplicates...

Couple of small index tweaks (just to add an extra included column):

CREATE NONCLUSTERED INDEX

[IX_SuggestedBy_JLG]

ON [dbo].[transactions_recon]

(

[TRWEEK] ASC,

[TRDATE] ASC,

[TRTIME] ASC,

[RecID] ASC

)

INCLUDE ([TRSITID],[TRPRODID],[Qty],[recordkey],OPIS) -- Added OPIS

WITH...

ChrisM@home (1/12/2012)

---

Paul, I assumed that you were suggesting that it's ok if the number of rows is not only small but is restricted, and I must admit I was more...

They will produce exactly the same results, yes. My comments would be that you should avoid the NOLOCK...

Jeff and Chris,

You've missed the point I was making, and have chosen to assume that I am either (a) not aware of the performance issues involved; or (b) that I...

I do understand your practical reasons for preferring option 2 (though...

When you are writing a post, there is...

SSC's Got Talent

Give this a whirl:

SELECT

S.SERVERIP,

ISNULL(C.VIDCOUNT, 0) AS VIDCOUNT

FROM

(

-- Distinct server list

SELECT DISTINCT...

drew.allen (1/11/2012)

---

That's true, but this statement from the original poster sounds like the GROUP BY is the correct version.

kevin_nikolai (1/10/2012)

---

If NOT 1st year and same Programme for same Student, then...

Greg Snidow (1/11/2012)

---

Thank you both for the tips. After doing some research (google), I believe I am working with a packed decimal field. I suspected this was the...

Please don't! My post was aimed at Cold Coffee, and was for interest only....

If you are running Enterprise Edition, you also have the option of Change Data Capture.

Not without something to enforce that uniqueness it isn't. 😛

CREATE TABLE #T (id int IDENTITY(1,1) NOT NULL)

INSERT...