ta 🙂

I still need to figure out a way of optimizing it too I guess

after some caffeine input I can see the logic is wrong there, thanks

after some caffeine input I can see the logic is wrong there, thanks

in my sql I have THEN t.LedgerAmount not t.LedgerType, even so, I'm bamboozled right now I'm afraid

I've been up since 3 this morning 🙂

I've run that but what does it tell me or what am I expecting to see?

Hi Chris,

what do you mean by actual execution plan?

The statement works - just if the result set (100+) is bigger than normal it takes over a minute whilst under that...

I may republish the previous post in the sql 2008 forum as I don't think it is sql azure related now.

Actually I may have been barking up the wrong tree. Running the sql below (which references the first view, which in turn references the second view) without the 3 SUM...

Thanks guys, I shall look into your advice.

That would just bring back the first alphabetical one and not the one that's on the same row of the maxdate one.

This does work - it seems a bit messy...

Changing that back to TOP 1 brings back all nulls for LastVisitDate and Desc apart from one row.

I can see why I had the wrong LastVisitDesc using MAX as it...

That's almost correct thanks! I get the expected row count and correct LastVisitDate but the LastVisitDesc is wrong.

I've tried it without MAX for LastVisitDesc and putting it into the...

I've found this similar problem/solution but am unclear on how to apply to my code

http://stackoverflow.com/questions/21254760/joining-with-max-date-from-table