Cheers for your suggestion, to get around this prior to my question I'm using the following SQL Query...

select

Q1 = case

when q1 = 1 then 'Poor'

when q1 = 2...

Hi Tom,

That code worked great. Just comparing them the only difference I can see is elseif in your code and the else if in my code. I find...

And then for the where clause you could use this...

where (exht - (datediff(hour,sampledate,getdate()))) < 24

It works over here.

Cheers,

Chris

Hello,

You could try this...

select sgd,

datediff(hour,sampledate,getdate()) as 'TimeIn',

(exht * 24) as 'ExHrs',

...

Ha, wonderful, it works like magic. Now I'll pull it apart to see exactly how you did it.

I'll go home tonoght and tell my wife that when we have...

Ha, wonderful, it works like magic. Now I'll pull it apart to see exactly how you did it.

I'll go home tonoght and tell my wife that when we have...

Good morning,

Thanks for your assistance on this one it's been a big help. The formula now works as it should.

Thanks again,

Chris

Thanks to Preethi this job is now complete. I modified the code slightly to read the following...

Select Distinct A.Call_ID,

...