Duplicate thread.

Hi Charlotte

Some sample data in the same format as you provided in this thread would help. Thanks.

Do you have to read the same table three times or would something like this work?

SELECT EditionID, Make, Model, EditionDesc, Value1

FROM t1

HAVING Value1 BETWEEN

(CASE WHEN Value1 <= @trig

THEN TRUNCATE(Value1-@tol1,1)...

There is a cheaty way to use a side-effecting function in a function, and that's to encapsulate it into a view, like this:

CREATE VIEW vw_srn AS SELECT srn = ABS(CHECKSUM(NEWID()))

GO

CREATE...

Use APPLY with a simple expression like this. Also, RAND operates as a run-time constant. NEWID doesn't, so you can generate a new value for each output row of your...

Peter Brinkhaus (7/29/2013)

---

I guess Paul will...

You can't get...

N.D (7/29/2013)

---

Ok, I popped the results into a temporary table. It's only giving the results (rn = 1) for either the first or the last year (depending on whether I...

There's an extra column in your output. You can filter on it, provided you set up the query as an inner query or CTE of an outer query wielding the...

Blimey MM if I was a snake oil brewer I'd want you leading my sales force! Whether you're on the right track or not, it's a great story!

Have a look...

select

backup_start_date as [Date],

((f.backup_size/1024)/1024) as [Database Size],

((f.file_size/1024)/1024) as [File Size],

RANK() OVER (PARTITION BY backup_start_date ORDER BY backup_start_date) AS Rank,

rn = ROW_NUMBER() OVER (PARTITION BY MONTH(backup_start_date) ORDER BY backup_start_date DESC)

from...

ssskumar4u (7/29/2013)

---

Hi Chris,

Thanks for your response.

It is the case that based on pattern matching, we have to retrieve the index number.

If pattern matching fails,then identify the error record...

The OP is now selling real estate in Argentina, 3 1/2 years later.

Margarett, if the leftmost part of the Desc column...

-- Stare & Compare: check it's likely to work

;WITH Updater AS (

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY category ORDER BY creation_date DESC)

FROM MyTable

)

SELECT *

FROM Updater

WHERE rn > 2

--...

Sean, there are more details here.