1 point for every 3 multiples in a row

Question

Post reply

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

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 · Answer 2

DECLARE @test-2 INT, @divisor INT

SET @divisor = 3

SET @test-2 = 6

SELECT @test-2 / @divisor AS '6'

SET @test-2 = 5

SELECT @test-2 / @divisor AS '5'

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

-- Cory

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

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)