Below is a portion of my load script:
//tdate as DATE,
date(tdate,'M/DD/YYYY') as DATE,
consult*billrate as ConsultBilled,
The BOLDED parts are billed hours. grpsz can be NULL or an integer. if grpsz = 1, then I want to add the value of IEPdirect to individual and then set IEPdirect=0 and "direct"=0. Let me say that if grpsz has a value other than NULL, then IEPdirect and "direct" will be greater than 0(zero).
Any ideas for me?