SELECT ID,CTID,CustomerName,MobileNo,TicketNo,[Status] FROM VIDComplaintDetails,StatusMaster WHERE ( @MOBILENO IS NULL OR MobileNo = @MOBILENO) AND ( @CTID IS NULL OR CTID = @CTID) AND ( @TNO IS NULL OR TicketNo = @TNO) AND ( @EMAILID IS NULL OR EmailID = @EMAILID) AND VIDComplaintDetails.ComplaintStatus = StatusMaster.StatusID
No comments:
Post a Comment