Changing values at specific points

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 2008 Forums

Transact-SQL (2008)

Changing values at specific points

Author

Topic

JohnMcLaughlin
Starting Member

28 Posts

Posted - 2011-03-29 : 07:49:09

This is my current SQL

SELECT PA_POLICY,PA_TRDATE,PA_EFFDTE,PA_TRCODE,PA_AMOUNT
FROM dbo.PA1
WHERE (PA_TRCODE = N'KF') OR
(PA_TRCODE = N'KT')

I would like to be able to make PA_AMOUNT negative when PA_TRCODE= KT.

Any help would be much appreciated.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-03-29 : 08:53:36

This should do that.

SELECT 
   PA_POLICY,
   PA_TRDATE,
   PA_EFFDTE,
   PA_TRCODE,
   case 
      when  PA_TRCODE= 'KT' then -PA_AMOUNT
      else PA_AMOUNT
   end as Signed_PA_AMOUNT
FROM 
   dbo.PA1
WHERE 
   (PA_TRCODE = N'KF') OR
   (PA_TRCODE = N'KT')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources