How to use case statement this Query

Jan 12 2012 11:46 PM

How to use case statement this Query.

(select SUM(VPRC_60.receipt_rf_amt) as Before from VPRC_60, VPRC_13 where VPRC_13.proj_adopt>= VPRC_60.dt_for and VPRC_60.receipt_rf_amt <> 0 and VPRC_60.Rpt_unit = VPRC_13.Rpt_unit)

Thanks&Regs

Manavalan

Answers (2)

SQL Query to compare two table values?

Cursor in SQL Server