JAYESH AJ

JAYESH AJ

  • NA
  • 97
  • 29.8k

07-2013(how to make query creating

Aug 7 2013 2:40 AM
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'

Answers (1)