Hi

Thanks for this - I'll try your solution when I return to work tomorrow (I've been on holiday for a couple of weeks). I'll let you know how it...

Sorry about the late reply, I've been away from my desk most of the time since my in initial post.

Anyway, thanks guys, I'm very grateful for your assistance which...

Hi guys

Cheers for the replies - worked a treat. I think my brain was on a 'go-slow' day yesterday - too many meetings, but you've helped a lot - I...

Hi Piet

Thanks for this - I have placed your code in our syntax library, so my colleagues can make their choice!

Cheers

-Rich

Thanks Kiara and Drew - this is great stuff and I shall share it with my colleagues to help them write more efficient SQL as like me they probabaly use...

That works perfectly and will be very useful in future too.

Many thanks

-Rich

Thanks for the reply.

However, I don't actually want the position of the characters i.e. I actuallly want the output to be:

either

Grade

M0

M1

M2

etc

or

Grade

0

1

2

Reason being I need to compare the numeric values...

Hi Wayne - works as well!

Such a simple thing has will increase the efficiency of myself and a few colleagues immensely.

Great stuff all round.

-Richard

Cheers and thanks for this - I didn't know until now that there was a 'reverse' of union so to speak.

-Richard

Hi Chris - it's ClientID.

Cheers

Thanks John - I've never heard of 'Except' but I'll look it up.

Cheers

Thanks Chris - looks a lot neater - the only problem I have is that the innermost select fails as the AppointmentDate field where I'm setting some date parameters only...

Hi Chris

That is brilliantly succinct.

Many thanks for all your assistance. I've run the query against a live database (test database earlier) and it also runs about 10 times faster than...

Hi Chris

This is brilliant, but I'm now trying to understand exactly how the following pieces of code retrieve a median value:

SELECT Seq = ROW_NUMBER() OVER (PARTITION BY PurchCode, Provcode ORDER...

Hi Chris

Thanks for the updated code. I'm not sure if I've done something wrong, but when I run it against our database I get the same results as before

Apologies...