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')