April 21, 2010

Search on any parameters SQL Server

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