#1 don't use "SELECT *". List out the exact columns you want.
#2 Your scalar function call (fn_GetTime) is not going to be quick. What is the contents of the function?
#3 Your WHERE clause is turning your LEFT join in to an INNER join. I don't know if that's the behaviour you want or not.
Thank you George! I hadn't seen anyone other than me mention #3 on any board or forum in the past. Which is really surprising as it seems to be a very frequent problem with developers that I have seen. Robert Catterall does make mention of it in his blog post on OUTER JOINS some years back.