SQL Query Help

• rs

  SSCrazy

  Points: 2819

  More actions

  July 13, 2004 at 8:04 am

  #152223

  I need help on this,

  CREATE TABLE MyTemp (ID INT,ITEM VARCHAR(10),USERID VARCHAR(15))

  GO

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (1,'CARS','SALESPERSON')

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (2,'CARS','MANAGER')

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (3,'CARS','REPRESENTATIVE')

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (4,'VAN','SALESPERSON')

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (5,'BIKE','SALESPERSON')

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (6,'BIKE','REPRESENTATIVE')

  INSERT INTO MyTemp (ID,ITEM,USERID) VALUES (7,'BIKE','MANAGER')

   

  I need SELECT * FROM MyTemp EXCEPT ITEM = 'BIKE'(IF USERID <> 'MANAGER')

  Looking for the following out put

  1 CARS SALESPERSON

  2 CARS MANAGER

  3 CARS REPRESENTATIVE

  4 VAN SALESPERSON

  7 BIKE MANAGER

  How can get the above output with one sql statement. Any help please.

   

  Thanks.

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  July 13, 2004 at 8:52 am

  #514407

  Is this what you want?

  select

   *

  from mytemp

  where

   item <> 'BIKE'

  or (item ='BIKE' AND userid = 'MANAGER')

  ???

  Regards

   

  Jamie Thomson
  http://sqlblog.com/blogs/jamie_thomson

• rs

  SSCrazy

  Points: 2819

  More actions

  July 13, 2004 at 1:56 pm

  #514458

  Thanks for your quick response.

  I did like this

  SELECT * FROM MyTemp 

  WHERE (USERID = 'MANAGER' OR ITEM <> 'BIKE')

  Thanks again.