JAYESH AJ

JAYESH AJ

  • NA
  • 97
  • 30.1k

sql query using due date add the one year

Aug 3 2013 3:18 AM
***********************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)