create proc GetLoans @YearID int ,@MonthID int as SELECT Users.FullName, Loans.AmountPaid, Loans.LoanDate FROM Loans INNER JOIN Contracts INNER JOIN Users ON Contracts.UserID = Users.UserID ON Loans.UserID = Users.UserID where LoanDate = ?
where month(loanDate)=@MonthID and year(loanDate)=@YearID
WHERE MONTH(LoanDate) = 4 AND YEAR(LoanDate)=2013
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)