Fire up Red Gates Dependency tracker to get a graphical representation of the db. Turn on trace. Check permissions to see who/ what is updating the db. ...

Sum(IIf([dteDate]<Now(),IIf([intAbsenceType]<=2,0.5,IIf([intAbsenceType]=3,1,0)),0)) AS Taken, Sum(IIf([dteDate]<Now(),0,1)) AS Planned

Use a Case Statement to resolve this complex iif statement. The case will take a condition when x then 5.

Jason

I use to have to do this when working with PeopleSoft SQR. We would dynamically create the .bat file. For example your file code could look like this:

line...