Oh no! Something went wrong!
A problem was encountered while processing your request. The incident reference code is:
We are sorry for any inconvenience this may have caused. Our technical team has been notified of this error. Thank you for your patience while we work to resolve the issue.
Text:
select i.*
from prmtinsp i
inner join prmt on i.prmtid = prmt.prmtid and i.isdeleted = 0
inner join luv_prmtinspstatus luv_i on i.[status] = luv_i.[status]
inner join lu_prmtinsp lu_i on i.lu_prmtinspid = lu_i.lu_prmtinspid
where prmt.isdeleted = 0
and luv_i.IsScheduled = 1 and i.prmtid = @pkid
and (prmt.prmtid in (select cr.pkid from contactrel cr where cr.isdeleted = 0 and cr.contactid = @contactID and cr.tablename = 'Prmt' and cr.other <> 42)
or prmt.prmtid in (select k.prmtid from prmtk k where k.isdeleted = 0 and k.contactid = @contactID))
and i.D_Insp > cast(getdate() as date)
order by i.d_insp : Text:
select i.*
from prmtinsp i
inner join prmt on i.prmtid = prmt.prmtid and i.isdeleted = 0
inner join luv_prmtinspstatus luv_i on i.[status] = luv_i.[status]
inner join lu_prmtinsp lu_i on i.lu_prmtinspid = lu_i.lu_prmtinspid
where prmt.isdeleted = 0
and luv_i.IsScheduled = 1 and i.prmtid = @pkid
and (prmt.prmtid in (select cr.pkid from contactrel cr where cr.isdeleted = 0 and cr.contactid = @contactID and cr.tablename = 'Prmt' and cr.other <> 42)
or prmt.prmtid in (select k.prmtid from prmtk k where k.isdeleted = 0 and k.contactid = @contactID))
and i.D_Insp > cast(getdate() as date)
order by i.d_insp : Failed to convert parameter value from a String to a Int32.