BEGIN IF (Status =0) THEN SELECT * , st.SRTech_Description AS RStatus, st.SRTechStatus_Name AS RSInitials FROM requestdeployment rd, sr_TechStatus st, SupportRequest SR LEFT JOIN Locations L ON SR.SR_SupportLId = L.Id WHERE Scc_id IN ( Con ) AND sr.SR_id = rd.requestid AND SRTechStatus_ID IN ( SELECT STATUS FROM requestdeployment WHERE RequestId = SR.SR_Id ) and rd.active!=1 and rd.deployedby=DPID and rd.status=st.srtechstatus_id; ELSE SELECT * , st.SRTech_Description AS RStatus, st.SRTechStatus_Name AS RSInitials FROM requestdeployment rd, sr_TechStatus st, SupportRequest SR LEFT JOIN Locations L ON SR.SR_SupportLId = L.Id WHERE Scc_id IN ( Con ) AND sr.SR_id = rd.requestid AND SRTechStatus_ID IN ( SELECT STATUS FROM requestdeployment WHERE RequestId = SR.SR_Id ) and rd.active!=1 and rd.deployedby=DPID and rd.status=st.srtechstatus_id and st.SrtechStatus_ID=Status; END IF; END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)