sql query using due date add the one year
***********************Partiqualr schemeA,schemeB select (4 days,one month)*********
CREATE PROCEDURE sp_fillng
(
@vScheme varchar(50),
@dDue_Date datetime,
@dtF datetime
)
AS
begin
select vLoan_No As LoanNumaber,dIssue_Date As Date,vParty_Id As CustomerName,dcLoan_Amt As LoanAmount,dDue_Date As DueDate from tbl_LoanMaster
WHERE vScheme=@vScheme and dDue_Date=@dtF+365 and vStatus='N'
end