case (Select Count(*) from ECSQ1Production..contact where (Nominatedforsurvey='true' and TPAccountID=Contact_InterimDbAccountId and NominatedforSurvey='true' and contactsurveystatus='complete'))

when '0' then '0'

else

(Select convert(numeric(5,2),Count(*)) from ECSQ1Production..contact where (Nominatedforsurvey='true' and TPAccountID=Contact_InterimDbAccountId and NominatedforSurvey='true' and contactsurveystatus='complete'))/(Select convert(numeric(5,2),Count(*)) ...

Yes. That solution I was directed to wasn't as helpful as I would have liked, so I thought maybe if I posted in this forum, I might find a...

Thanks. But what about compressing the .bak files into .zip files and deleting the .bak back files to save on space? Any ideas?