Luis, Gail and Sean, Thanks for your comments on this post. Including OP, anyone else who is following this post, will add something to his Knowledge.

Luis, I disagree on not using NOLOCK. Even my project uses it in all reporting queries, and removing NOLOCK will result in tons of calls and mails at helpdesk.