select candidate_key,

CASE WHEN ROW_NUMBER() OVER ( PARTITION BY candidate_key, MAX(date_test_taken), LEFT(REPLACE(NAME,'260913','100613'), LEN(ssl.name)- 1) ORDER BY value DESC, REPLACE(ssl.NAME, '260913','100613') DESC ) = 1

...

In case you didn't know, when i went to mass on Sunday the priest said the bunny rabbit was the first to see Christ when he was Resurrected...hence the reason...

Don't ask permission to utilize new technology...beg forgiveness.

I worked for a particular company as a contractor that depended on C# classes to do imports. My project called for a new...