CirquedeSQLeil (5/20/2010)

---

Paul White NZ (5/20/2010)

---

Chris Morris-439714 (5/20/2010)

---

Paul White NZ (5/20/2010)

---

Chris Morris-439714 (5/20/2010)

---

Paint...

david.woulds (5/20/2010)

---

Chris, well it's basically determined by the current month which comes from:

datepart(month,getdate()) as I use this the get the FY start and end dates. I just need to incorporate...

;WITH SequencedTable AS (

SELECT GroupID = ROW_NUMBER() OVER (PARTITION BY cRightID ORDER BY cDesc)

FROM dbo.SMRights)

DELETE FROM SequencedTable WHERE GroupID > 1

-- Note that the choice of sort column is up...

Huh?:ermm:

Oh John...I always thought you were one of us good guys...

Paint tin? :Whistling:

david.woulds (5/20/2010)

---

Chris, I tried the code you suggested might work, but doesn't seem to like the word DECLARE

I used your suggestion re WHERE datepart(month,getdate()) >3 and the following code...

Good Lord! Lighten up, guys!

wmalik001 (5/20/2010)

---

Guys, thank you for your reply,

But i am getting this error:

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE...

Hi David

I've no idea whether or not BO would permit the use of variables, however, they will certainly assist you in creating and debugging a SQL statement - after which,...

Using @variables makes the code much easier to read - for the purposes of figuring out the problem, if nothing else. The same applies to using table aliases - 'p'...

;WITH SequencedTable AS (

SELECT GroupID = ROW_NUMBER() OVER (PARTITION BY DuplicateColumn1, DuplicateColumn2, ...)

FROM dbo.SMRights)

DELETE FROM SequencedTable WHERE GroupID > 1

Speak to Barry - he's got his modulus back 😀

Sounds like the outlaws. Wassup Paul?

:-D:-D