07-2013(how to make query creating

dIssue_Date (currently date one year adding display )



CREATE PROCEDURE sp_displaycustomer
(
@vScheme varchar (50),
@vStatus varchar(50)

)
AS
begin



select vLoan_No as LoanNumber,vParty_Id as CustomerName ,dIssue_Date as DissueDate,dcLoan_Amt as LoanAmount from tbl_LoanMaster

WHERE vScheme =@vScheme and dIssue_Date>=365 vStatus='N'