Thanks Dinakar,

This seems to work.  I had to add the servicereq column to the table.

CREATE PROCEDURE MonthlyComplianceServiceOrdertest @iYear nvarchar (4) ,@sMonth varchar (4)

AS

SELECT   (CASE WHEN dbo.tblCompliance.MechLDDue IS NOT NULL THEN...