Got into the trap...thought query may return 1 or 2....overlooked the primary key factor :w00t:
A good question though. Thanks for posting.
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter