Update the rows which are divisible by 10

Question

Post reply

Update the rows which are divisible by 10

Ganapathi M

Say Hey Kid

Points: 707
More actions
September 4, 2007 at 12:36 am

#153791

Hello All,
How would you Update the rows which are divisible by 10, given a set of numbers in column?

Regards,
Ganapathi M

Viewing 9 posts - 1 through 8 (of 8 total)

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

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Ganapathi,

somthing like this should work:

Update

myTable

Set col1 = Col1 + 5 -- Put your new value here

where Col2%10 = 0

Markus

[font="Verdana"]Markus Bohse[/font]

Ganapathi M Say Hey Kid Points: 707 More actions · Answer 2

Ganapathi M

Say Hey Kid

Points: 707

September 5, 2007 at 4:16 am

#731435

Thanks Markus,

Its Working!!!

Ganapathi.

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

Ganapathi,

It's good that the code works... but do you know WHY it works?

--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)

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 4

Oh well, I tried... looks like yet another newbie got what they wanted but not what they needed... knowledge

Peso, ol' friend... if you read this, looks like you were right... new breed of Yak is taking over

--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)

steve block SSCertifiable Points: 7698 More actions · Answer 5

steve block

SSCertifiable

Points: 7698

September 10, 2007 at 8:12 am

#732493

Must have been a homework assignment!

Steve

Ganapathi M Say Hey Kid Points: 707 More actions · Answer 6

10/2 = 5

10%2 = 0

% is called Modulo division. It will gives us the Quotient value. In our example

Quotient is 0 suppose if i give 11/2 then output will be '1'.

The same logic is applied in the update statement.

Jeff, am i correct ?

Sblock, i cannot do my assignment in my school days.

Regards,

Ganapathi

Jeff Moden SSC Guru Points: 1004362 More actions · Answer 7

Yep... you've got it... just wanted to make sure

--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)

steve block SSCertifiable Points: 7698 More actions · Answer 8

Just curious, what practical application did you need this for. The question sounded more like something you would use in an academic situation and therefore my suspicion that it was for homework. Sorry.

Steve