If you add the full timecol to this then it would sort the "6 hours" and "6 hours 30 minutes" properly.

SELECT...

As long as the values in tab2.col2 are unique, this will return the closest match to tab1.col1. Also, this doesn't return anything for values in tab1.col1 that don't match anything...

I think the JOIN makes it easier for others to understand the code and how the tables are joined. If you have a number of tables joined using a WHERE,...

I hate when I don't read the question correctly. I got my logic flipped when I didn't read "not" allowed.

I take it that the process is in a certain state from the first record with that state until the first record with a different state or the end of...

How many shops don't have a development or testing server to clone it to?

Maybe something like this?

SELECT t1.ItemNumber

FROM testtable t1

INNER JOIN testtable t3

...

And what are your questions?

Here's another approach...

SELECT Pl.PlayerFirst AS Player,

COUNT(ALL Sc.Finished) AS Events,

SUM(CASE

...

When the question of the day is incorrect, everyone keeps posting the same thing over and over. Maybe we should have a standard reply form:

-------------------------------------------------------------------------------

I selected A ...

It's important for a company to not have someone who is indispensable. It isn't that they have too leverage over a company, it's that they might just quit or, as...

Wouldn't that get you the number of columns in the cursor, not the number of rows?

I appreciate the difficulty in creating questions that can withstand the pounding on these forums. I do find it ironic when posters slam the question for being wrong and then...

I originally thought the 1 and 0 were switched but actually, the two comparisons should be >=