6
Reply

QUERY CHECKING

JAYESH AJ

JAYESH AJ
Jul 31 2013 7:31 AM
905
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)
Next Recommended Forum