Professional Web Applications Themes

Switching between "IN" &"NOT IN" statements - Microsoft SQL / MS SQL Server

i have a stored procedure something like as follows FROM tblStocklist WHERE strVenName IN(SELECT strVenName FROM tblProVen ..etc i want to change the "IN" to "NOT IN" based on the value of a table field. can anyone suggest a solution?...

  1. #1

    Default Switching between "IN" &"NOT IN" statements

    i have a stored procedure something like as follows

    FROM tblStocklist
    WHERE strVenName IN(SELECT strVenName FROM tblProVen ..etc

    i want to change the "IN" to "NOT IN" based on the value
    of a table field.

    can anyone suggest a solution?
    Carlton Guest

  2. #2

    Default Re: Switching between "IN" &"NOT IN" statements

    You can use a CASE expression to do such queries. If you can post an exact
    repro illustrating your requirements clearly someone here can show you how.
    In certain cases you will have to use IF ...ELSE constructs depending on
    what you are doing.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: Switching between "IN" &"NOT IN" statements


    "Carlton" <com> wrote in message
    news:1dcd01c36102$784bd390$gbl... 


    .........

    FROM tblStocklist
    WHERE
    ( CASE WHEN strVenName IN(SELECT strVenName FROM tblProVen ..etc ) THEN 1
    ELSE 0 END ) = UseInColumn

    where UseInColumn is a bit column, or an expression that returns a bit of 1
    when you want "IN" and 0 if you want "NOT IN"





    Louis Guest

  4. #4

    Default Sorted Thanks All

     
    carlton Guest

Similar Threads

  1. CFINPUT type="radio" w/ "value" requires "label"
    By Iceborer in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 21st, 06:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139