Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
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 "
|SSRS 2012 r2 - Parm Drop Down has Date/Time||12||42|
|Check ALL SP in database make sure there are no errors||17||46|
|Access join syntax when converting to T-SQL query||4||37|
|What is this datetime?||1||20|