Thanks for the help!

It is true (of course) that the WHERE clause sorts out the LEFT OUTER JOIN (thanks). The only niggle is I remember moving the a.batch =...

Thanks Lius, it does bring the same results.

I'm guessing this method would be more efficient when dealing with large tables (as this query will have to do)?

Changing the column datatype to float produced the desired effect. Was going to CAST AS FLOAT etc. Never thought of this solution.

Thanks yet again 😀

Think I got it.

SELECT ID, layer, result/result1

FROM ( SELECT ID ,

...

Thanks Stuart.

I have edited my original post as I mixed up my temp table name with my SQL query so far. Sorry for that.

Basically I want to multiply...

As a NooB to SQL I do tend to like what I actually understand (it was just nice to see a solution I understood before I ran it etc) .......................but...

Gotta say I like that last one ccavaco. Very easy to understand. (in fact the ONLY one I understand 🙂 )

Thanks!

OMG so many ways!!! This community is great 🙂

Thanks for that. That turned out way more complex than I ever imagined for what appears (in theory) to be a simple retrieval of a couple of rows of...

Yes it was the addition of the = to my efforts without doing the same to the answers provided.:blush:

Both answers were (of course) correct.

Thanks again.

Erm... tried both answers and got different (and unexpected) results.

I'll explain better perhaps in case I didn't before (guilty of that way too often).

How would I get say the SUM...

Yes! That is exactly what I have spent the last week trying to achieve.

Thanks so much.

Could I just asked if I wanted the opposite of the results would the only...

Sorted it. Jans solution was correct. The difference in our results comes from the query using the differnece between the last value from the previous day and the...

This is my code for one column but I cannot work out how to get counts of multiple columns for the 'rollover' count.

DECLARE @T TABLE

(ndx INT...

Jan,

Thanks, but this is not the result I am after. My table has three count columns (open_front, open_rear, wrap_count) plus a timestamp of when the record was added (t_stamp)....