OK...got this to work (partially):

SELECT

(row_number() over(partition by RaceID order by [Actual Time])

)as RacePlace,

(count([Actual Time]) over(partition by RaceID)

) as raceCount,

CAST(

1.*(row_number() over(partition by RaceID...

darn... drat... curse....

sorry this has taken sooooooo long to test!!

ive tried:

SELECT row_number() over(ORDER BY [Handicap Time]) as RacePlace, [Actual Time], [Handicap Time]

FROM...

Thankyou for this imput, guess i still can't get "link" tables into my thinking, but this makes perfect sense!

I Can assure you you...

thanks a million!..... change results??......me???.....NEVER!!! 😉

the problem with the advised code:

SELECT (ROW_NUMBER() OVER (PARTITION BY r.RaceID, ORDER BY someresultformula)) /100 AS Percentile,

...

Forgive me...have to ask....

I presume you concur it's a bad design idea to include the "percentile" information in the table?

Ok, what i mean is that the row number in & of itsself is meaningless unless you know how many runners were in the race. What I'm looking for is...

OK... thanks for this & yes those commands seem to be what i was looking for, whilst i appreciate that presenting all the required data tables would result in a...

I think i am beginning to understand why it is i dabble in programming...thanks for the insight RBarry!!

Obviously if Halle Berry were to encounter you I am confident she would...

I'm afraid i don't know normalisation other than the barest fundamentals, which ...if i was forced to answer would be to seperate anything "repeatable" into its own table!?

I think what...

OK here is the SQL...it's workin as intended although i still want to tweak it a little:

SELECT

dbo.Results.rFastest, dbo.Results.rPercentile, dbo.Results.rGrpID, dbo.Results.rCurrentMember, dbo.Results.rChampPoint,...

Seems the error i was getting in the last sql statement was an overflow... it was looking at miliseconds difference & consequently soon ran over the limit. So Im about...

I think that you have to use DATEDIFF and DATEADD functions. So instead of this:

dbo.Results.rTime - dbo.Results.rHandicap

you would have to use this:

DATEADD(mcs, - DATEDIFF(mcs, dbo.Results.rHandicap, 0), dbo.Results.rTime)

I haven't tried...

OK seems I'm more of a newb than anyone realises (even me)

the "UI" i was referring to was within visual web developer ..... i havent found any other means to...

OK i've read how to post correctly... but .... well im a newby, so im afraid i use the UI to create tables... ill post definitions if that helps?

and the...