Bug #9032
Updated by Anonymous over 6 years ago
WHERE EntityID=@entityId AND SourceID=@sourceId AND SubSourceID=@subSourceId AND ProblemClassID=@probClassId
AND ConcernTitleID=@concernTitleId AND ISNULL(CustomerID,0)=ISNULL(@customerId,0)
and ConcernStatusID=@statusId
AND ISNull(Department,'DBNULL')=isnull(@department,'DBNULL')
AND ISNULL(PartID,0)=ISNULL(@partId,0)
AND ISNULL(FailureModeID,0)=ISNULL(@failureModeId,0)
AND IsNull(Initiater,'DBNULL')=ISNULL(@initiator,'DBNULL')
AND Isnull(CustomerProbDescr,'DBNULL')=IsNull(@custProbDesc,'DBNULL')
AND Isnull(Bol,'DBNULL')=isnull(@bol,'DBNULL')
AND isnull(ContactEmailID,'DBNULL')=isnull(@contactEmail,'DBNULL')
AND Isnull(ContactNumber,'DBNULL')=Isnull(@contactNumber,'DBNULL')
AND Isnull(CostDescription,'DBNULL')=isnull(@costDesc,'DBNULL')
AND isnull(CAST(DeliveryDate AS VARCHAR(20)),'1990-01-01')=isnull(CAST(@deliveryDate AS VARCHAR(20)),'1990-01-01')
AND Isnull(Lot,'DBNULL')=isnull(@lot,'DBNULL')
AND IsNull(PriorityID,0)=ISNull(@priorityID,0)
AND Isnull(ProblemDescription,'DBNULL')=Isnull(@problemDesc,'DBNULL')
AND Isnull(ProcessID,0)=Isnull(@processId,0)
AND Isnull(ProductID,0)=Isnull(@productId,0)
AND Isnull(CAST(ReportedDate AS VARCHAR(20)),'1990-01-01')=isnull(CAST(@concernReportedDate AS VARCHAR(20)),'1990-01-01')
AND Isnull(SeverityID,0)=Isnull(@severityID,0)
AND Isnull(Supplier,0)=Isnull(@supplier,0)
AND Isnull(ApproachID,0)=Isnull(@approachId,0)
AND Isnull(TeamID,0)=Isnull(@teamId,0)
AND Isnull(TeamLeadID,0)=Isnull(@teamLeadId,0)
AND Isnull(ProjectID,0)=Isnull(@projectId,0)
AND Isnull(ProjectStatusID,0)=Isnull(@projectStatusId,0)
AND Isnull(ChampionComment,'DBNULL')=isnull(@championComment,'DBNULL')
AND Isnull(VerCorrAction,'DBNULL')=isnull(@verCorrAction,'DBNULL')
AND ISNULL(CAST(VerCorrActDate AS VARCHAR(20)),'1990-01-01')=isnull(CAST(@verCorrActionDate AS VARCHAR(20)),'1990-01-01')
AND ISNULL(Comments,'DBNULL')=ISNULL(@comment,'DBNULL')