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 8, 2013 at 5:26 am

    #1656677

    Bhuvnesh (10/8/2013)

    select * from TABLE where countryid = @country

    select * from TABLE where countryid = @country OR stateID = @stateid

    select * from TABLE where countryid = @country OR stateID = @stateid OR Cityid = @Cityid

    Here @country ,stateID and @Cityid are parameters.

    SELECT * FROM TABLE WHERE countryid = @country

    SELECT * FROM TABLE WHERE countryid = @country AND stateID = @stateid

    SELECT * FROM TABLE WHERE countryid = @country AND stateID = @stateid AND Cityid = @Cityid

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden