Split the Table into positive and negative values

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Input Table
-----------

Id Value
1 500
2 -250

output should be

id positives negatives
1 500 NULL
2 NULL -250

Posted 5-Jan-15 19:19pm

vallambotla peraiah

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Answer 1 · 2015-01-05T19:56:00

Solution 1

try this

SQL

select a.id, 
"posit" = case
  when a.value > 0 then 'pos'
  else null
end ,
"negat" = case
  when a.value < 0 then 'neg'
  else null
end 

from  table a ;

Posted 5-Jan-15 19:56pm

pradiprenushe

Updated 5-Jan-15 20:22pm

v3

Comments

Shweta N Mishra 6-Jan-15 3:38am

+5

pradiprenushe 6-Jan-15 4:38am

thanks

Maddy selva 6-Jan-15 23:53pm

my +5

Split the Table into positive and negative values

1 solution

Solution 1

Add your solution here

Preview 0

Split the Table into positive and negative values

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us