6
Answers

sql query using due date add the one year

JAYESH AJ

JAYESH AJ

11y
1.3k
1
***********************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       
Answers (6)