Post reply

Exclude data set when another is chosen

  • February 10, 2009 at 8:40 am

    #130838

    I want a generic way to limit what data sets can be chosen at the same time. For example:

    Products

    A

    B

    C

    In the same query, if product A is chosen, product B is not allowed. But product A and C can be included in the same query. The code needs to be flexible if possible (not limited to a certain field or group of fields).

    Thanks for any insight.

  • February 10, 2009 at 10:39 am

    #941452

    "In the same query, if product A is chosen, product B is not allowed. But product A and C can be included in the same query. The code needs to be flexible if possible (not limited to a certain field or group of fields)."

    Do you want to pickup alternative records like Even or Odd??

    Thanks

    Vijaya Kadiyala

    http://dotnetvj.blogspot.com

    Thanks -- Vijaya Kadiyala
    www.dotnetvj.com
    SQL Server Articles For Beginers


  • February 10, 2009 at 11:24 am

    #941492

    No, that is not the goal. The records can be anywhere in the table, and need to be excluded based on field values, not any specific position in the table.

    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply