I am trying to write a query in Argos that uses nested case statements, but I keep getting a syntax error. Can anyone point it out to me?
case lsenrmngt_rec.plan_enr_sess when 'FA' then case lsenrmngt_rec.enrstat when 'READMIT' then case when lsenrmngt_rec.deg matches 'A*' then case lsenrmngt_rec.plan_grad_yr when year(current) or year(current+1) then readm2a+1 end end end readm2a
Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.