• Thanks hunchback, Sean Lange and dwain.c for help.

    I'm going with CROSS APPLY as it has least logical reads and lesser cost then other two.

    Thanks Again.