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.

  • October 9, 2013 at 2:36 am

    #1657028

    Luis Cazares (10/8/2013)

    What about normalizing data?

    Absolutely. If you have any control over the structure of the table, you should remove the CountryId and StateId columns, since they are attributes of the city, not of the user.

    John