SELECT count(*), ( case when PICSTATUS = '11' then 'Transfer Rejected' when picstatus = '12' then 'Transfer Cancelled' when picstatus = '20' then 'New Sale' when picstatus = '70' then 'Pricing Accepted' when picstatus = '72' then 'Sale Confirmed' when picstatus = '80' then 'Ready for Transfer' when picstatus = '90' then 'Transfer in progress' end ) as STATUS FROM PROCONSUMER WHERE PICSTATUS NOT IN (100,10) GROUP BY PICSTATUS "
|Using Case in sql queries||17||58|
|Bubble user-defined Sql RAISERROR(...) to c# exception||14||117|
|Strings no problem but cannot enter numeric variable into SQL Select statement||7||30|
|Oracle - Create Procedure with Paramater||16||32|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!