Viewing 2 posts - 1 through 2 (of 2 total)
Thanks all for your quick assistance!!
I ended up with:
CONVERT(INT, 100 * (CASE EXPECTEDDURATION WHEN 0 THEN 0 ELSE 1.0 END - CONVERT(FLOAT,
(dbo.fn_GetWorkingDays(TASKSTARTDATE, GetDate())* 8)) / CONVERT(FLOAT, CASE
EXPECTEDDURATION WHEN 0...
July 13, 2010 at 5:34 am
#1191924
Ok, I will dive into the CASE thingy to see if that will help me.
The 'business' is our team. We are now using a couple of our own web interfaces...
July 13, 2010 at 4:01 am
#1191870