Problem while using in operator

• shankartup

  Valued Member

  Points: 62

  More actions

  July 28, 2008 at 2:39 am

  #77054

  HI all,

  i am facing a problem while passing arguments using in operator

  i have a master table colors and a transaction table colordetails

  select Colorname as ColorName from colors where colorid in(3,6,37,0,0,0)

  select Colorname as ColorName from colors where colorid in(6,37,3,0,0,0)

  this is the query

  when we are using in operator it sorts and retrieves the record.

  but my requirement is that the order should not be changed..

  Help me

  Thanks

  Shankar.N

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  July 28, 2008 at 4:03 am

  #849030

  shankartup (7/28/2008)

  ---

  HI all,

  i am facing a problem while passing arguments using in operator

  i have a master table colors and a transaction table colordetails

  select Colorname as ColorName from colors where colorid in(3,6,37,0,0,0)

  select Colorname as ColorName from colors where colorid in(6,37,3,0,0,0)

  this is the query

  when we are using in operator it sorts and retrieves the record.

  but my requirement is that the order should not be changed..

  Help me

  Thanks

  Shankar.N

  There is no "order by" in your query so SQL Server will give you the results in the order it feels like. You can only prevent this by adding an "order by" to your query. e.g.

  select Colorname as ColorName from colors where colorid in(3,6,37,0,0,0) order by Colorname

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• Goldie Lesser

  SSCertifiable

  Points: 6155

  More actions

  July 29, 2008 at 12:43 pm

  #850066

  Do you want the results in order by the color id?

  Or do you want the results returned in the input order?