Bob, thanks for the link.

Problem with your solution when @count < word count of description then nothing returned here's a fix:

declare @count int

set @count = 10000

DECLARE @temp1 TABLE (ID INT...

Ahhh, beat me to it Bob, been banging my head against the wall trying to get it to work on a table...

DECLARE @temp TABLE (ID INT IDENTITY(1,1) PRIMARY KEY...

GSquared,

I had to update CTE slightly to get it to work on my system?

;with CTE as

(select row_number() over

...

I didn't either! follow the link and read (a lot;) and you'll get more tools in your bat-belt.

Does this give you what you need?

SELECT TOP 100 PERCENT

towergrid_reference_natowers.origin_latitude as [Latitude],

towergrid_reference_natowers.origin_longitude as [Longitude],

SUM(CASE WHEN...

///Edit - wrong thread

Cool, that's pretty

Hi,

have you any criteria for which record to keep?

Like is there a date field you haven't mentioned and you want to keep the most recent record, or do you just...

Hi,

Not really sure what you are after here!

Does the query you posted give the results you want?

Allister

Thanks for the feedback!

Hi,

Thanks for posting the test data and sorry for delay getting back to you!

Here is a solution, hope it helps.

Allister

SELECT WithRow.MerchantID, MerchantLegalName, RequestAmount, RequestDate

FROM

(

SELECT

...

Hi there,

One option may be to do a join on the two tables, add a row number and filter on that.

You'll get better answers if you can post some table...

Tim,

I'll hopefully have a chance to run some more tests today, couple of questions, just to get representative data: 30 million records, 15,000 employees, how many companies? what is the...

Hi Tim,

No, OPTION (MAXDOP 1) prevents parallelism occuring for the quirky update.

I re-ran test on 20 million records of test data, i.e. (quirky) updating the seq and diff as per...

Hi there,

trying this out on around 9 million rows and just updating those records that I needed to execution completed in a couple of seconds.

DECLARE @Seq ...