1 point for every 3 multiples in a row

• dheer

  Ten Centuries

  Points: 1275

  More actions

  January 10, 2011 at 9:50 am

  #232840

  Hi,

  I need to assing 1 point for every 3 multiples in a row for expample

  col1 6 then col2 should be 2

  if col1 5 then col2 should be 1

  Thanks

• Jeff Moden

  SSC Guru

  Points: 1004642

  More actions

  January 10, 2011 at 9:55 am

  #1271490

  Simple Integer math should take care of it...

  SELECT Col1/3

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Cory E.

  SSCertifiable

  Points: 7076

  More actions

  January 10, 2011 at 9:56 am

  #1271493

  DECLARE @test INT, @divisor INT

  SET @divisor = 3

  SET @test = 6

  SELECT @test / @divisor AS '6'

  SET @test = 5

  SELECT @test / @divisor AS '5'

  Edit: I guess Jeff beat me to it. Thanks!

  -- Cory

• Jeff Moden

  SSC Guru

  Points: 1004642

  More actions

  January 10, 2011 at 5:16 pm

  #1271671

  Cory E. (1/10/2011)

  ---

  Edit: I guess Jeff beat me to it. Thanks!

  Apparently, only by a couple of seconds! Great minds think alike. 🙂

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)