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'