How to put IF conditions on COLUMN NAMES...

[didajosh]

Hi,



My table is like

A/C_NO----BUD_00------YTD_00------BUD_01-----YTD_01-----BUD_02-----YTD_02
014-----------1000------------10---------------1000---------20------------1100-----------30

the result I want is something like:


A/C_NO----BUD_01------EXP_01
014-----------1000------------10

BUD shows the budget
EXP_01, is the EXPENSE in period 01,
which is calculate as the period specific expense and calculated as
(YTD_01) - (YTD_00).

User selects, which period, he wants the information for, like 00,01,02

How do I do this….I am clueless…. :-o

-dipali

[debasisdas]

in which part you want to use IF condition ?

[amitpatel66]

I think from the information that you have provided you are looking at using a WHERE condition in your query.

SOmething like SELECT col1,col2,col3 FROM table_name WHERE period = '00' (This can be a input parameter and can user pass in the value 00,01 or 02)

[didajosh]

Thank you all, this issue had been resolved.

[Pilgrim333]

Hi,

Explaining your solution could help others.

Pilgrim.

[didajosh]

I used CASE here.
e.g
select column names,
(CASE
when (:PERIOD) = ('01')
THEN ((YTD_01) - (YTD_00))

WHEN (:PERIOD) = ('02')
THEN ((YTD_02) - (YTD_01))

END)
as EXPENSE


Regards,
Dipali