Interesting query

• JKSQL

  SSCrazy Eights

  Points: 8481

  More actions

  April 28, 2009 at 8:44 am

  #130896

  I am aware of what a bitmask is but I have never really seen it used. In SQL they are doing a select like this in order to get the right answer....

  select * from material where materialuse0 & 2 = 2

  Can someone explain how this works? also maybe what it is doing

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  April 28, 2009 at 8:54 am

  #985185

  A good explanation along with sample code and resulsts for bit masking is in BOL at:

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/20275755-4fa7-47b1-a9be-ac85606d63b0.htm

  and:

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/f38f0ad4-46d0-40ea-9851-0f928fda5293.htm

  and

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/02da8016-f6c0-41ae-8d59-33eaa02bfc95.htm

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]