• could anyone suggestion me as below coding condition matching or not? if diff value = 0

    if NOT EXISTS (Select A.MACHINE, A.Instance, B.InstanceA,

    (B.InstanceA-A.Instance) as Diff from (select MACHINE, COUNT(*)

    as Instance from PROD.dbo.CM_INSTANCE group by MACHINE) A,

    (Select COUNT(*)/4 as InstanceA from PROD.dbo.CM_INSTANCE) B

    where (B.InstanceA-A.Instance) < -3 or (B.InstanceA-A.Instance) > 3)

    begin

    EXEC msdb.dbo.sp_send_dbmail @profile_name='db_mail',

    @recipients='ananad.murugesan@ril.com',

    @subject='Alert!-Verify LIMS Instance',

    @query= 'Select A.MACHINE, A.Instance, B.InstanceA,

    (B.InstanceA-A.Instance) as Diff from (select MACHINE, COUNT(*)

    as Instance from PROD.dbo.CM_INSTANCE group by MACHINE) A,

    (Select COUNT(*)/4 as InstanceA from PROD.dbo.CM_INSTANCE) B

    where (B.InstanceA-A.Instance) < -3 or (B.InstanceA-A.Instance) > 3'

    end