help create an update based on difference between

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

help create an update based on difference between

Author

Topic

midan1
Starting Member

39 Posts

Posted - 2008-06-29 : 03:37:25

i need help create an update based on difference between two fields
can you help me to build an update based on difference between two fields
i use only the numbers 1,2,3,4
so the difference can be only with this numbers can bee only 1 between 4 OR 0

like if the difference between two fields +1 than add 1

if the difference between two fields +2 than add 2

if the difference between two fields -2 than add 2
........................


UPDATE table

declare @new_unit

set @new_unit--- the user want to write the value he need (only between 1 and  4 )

SET unit =

--- CASE +

WHEN (@new_unit-unit)= -1

THEN unit -1

CASE

WHEN (@new_unit-unit)= +1

THEN unit +1

WHEN (@new_unit-unit)= +2

THEN unit +2

WHEN (@new_unit-unit)= +3

THEN unit +3

WHEN (@new_unit-unit)= +4

THEN unit +4

--- CASE -

WHEN (@new_unit-unit)= -1

THEN unit -1

WHEN (@new_unit-unit)= -2

THEN unit -2

WHEN (@new_unit-unit)= +3

THEN unit -3

WHEN (@new_unit-unit)= -4

THEN unit -4

--- CASE =0

WHEN (@new_unit-unit)= 0

THEN unit=unit


END 

 


END

TNX

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-29 : 05:11:13

declare @new_unit

set @new_unit=value--user input value (1,2,3,4)

UPDATE table
SET unit =unit + (@new_unit-unit)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources