Jeff Moden (10/8/2013)
Gosh, I wouldn't rely on that nuance especially for the sake of clarity.
Thanks Jeff for keeping close eye on all the replies , it actually helps me a lot .. you know your quoted word "GOSH" made me to read your and mine first reply 6 times to see what mistake i made and then finally realised that
i overlooked the below OP's text.
I need data based on
1. CountryId
2. CountryId and StateId,
3. CountryId, StateId and CityId
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)