JAYESH AJ

JAYESH AJ

  • NA
  • 97
  • 29.9k

QUERY CHECKING

Jul 31 2013 7:31 AM
Alter PROCEDURE sp_over                        
(     
  @vParty_Id 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 vParty_Id>=@vParty_Id and dDue_Date<=@dtF  and vStatus='N'    

end 

Answers (6)