+1 @sean
And to the OP, if you do post a question without sample data/DDL for the tables needed (etc), at least attach an actual execution plan - as most of the "experts" on this forum will typically take a stab at it if that's been included in your post.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience