Sorry for the delay lads

Sean, apologies I'm on here long enough to know what I should have included with this one, please see below for sample data and existing query:

CREATE...

Thanks for all the help on this guys, all answers were good, vladan's made the most sense on this

I think what was bugging me most was that I had it...

But why doesn't Partition By sp.Name order by sp.Name work in that regard?

I've tried dumping the result set into a temp table and doing the same (removing any problems that...

Hi vladan, that works, thank you

I still don't understand though why the partition by sp.name order by sp.name doesn't work here.

From my understanding it should be doing the same thing

Cheers Gail

No Gila, you're supposed to say just flick it over to 110 and everything will be fine 🙂

Thought as much anyway, it should be ok as I have some good...

Hi Gila - In terms of testing what the implications would be for changing the compatibility mode from 90 to 110, what would be the best way of verifying that...

Not sure Frank, it was quite sometime ago and it was in a different company so I don't have access to the stuff I was using then.

Best I can remember...

Thought it might be something like that, thanks for the clarification Tom

Unfortunately for me, this is the first of many sp's I'll be changing which all have a number of...

Can anyone tell me the 'official' reason why such behaviour occurs on SQL server when comparing float values.

If I run my code again, the values might match and I...

Forget the NULLs, it was down to the floats.

While investigating this I started using other queries using joins and comparing one value to the other in a WHERE clause which...

Thought so too but unfortunately it still seems to be failing the EXCEPT comparison.

If I wrap ISNULLS around these values with a 1 for replacement value it works

If I cast...

My guess is that this is something around local policy on the machine. Unfortunately, all of this is locked down so I can't look into it further but having similar...

The job step is running under proxy/credential which runs fine when the job owner is sa or running under my colleague. When the job owner is set to me fails...

Cheers Matt, worked a treat.

Don't suppose you have any experience with setting up a SAS data set as a linked server by any chance?