Home Forums SQL Server 2008 T-SQL (SS2K8) Filter Countries, States and Cities which in same row in one table. RE: Filter Countries, States and Cities which in same row in one table.

  • 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;-)