What's the correct syntax for converting this to SQL:
IIf(IIf(CAST(RQ.RQ_JOB AS DECIMAL) < sf.PeriodOrderedQty, 0, CAST(RQ.RQ_JOB AS DECIMAL)- sf.PeriodOrderedQty) <> RQ.RQ_QTY_REQ,'Yes','') AS [Update PK Qty Required?],
Thanks
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
