select vLoan_No as LoanNumber,dIssue_Date as Date,vParty_Id as CustomerName,dcLoan_Amt as LoanAmount, dDue_Date as DueDate from tbl_LoanMaster
WHERE dIssue_Date BETWEEN
convert(varchar,@dtFrom,101) and convert(varchar,@DtTo,101)and vStatus='N'
dtfrom= 9-92013 and DtTo=10-9-2013 ans corect>>>>>>
But dtfrom= 9-92013 and DtTo=9-9-2013 (how can query creating curent checking how?
Loading
JAYESH AJPosted Sep 10, 2013, 8:13 AM
WHERE dIssue_Date > = '25-jul-2013' and dIssue_Date < ='25-jul-2013' and vStatus='N'
-- Date >= '9-9-2013' and Date <= '9-9-2013'
display the Loan N,date,CustNmae ........
value not display
********************************************
CREATE PROCEDURE ln_DailyIssueReport ??????????? orginal type
-- Add the parameters for the stored procedure here
(
@dtFrom datetime,
@DtTo datetime
)
AS
BEGIN
SET NOCOUNT ON;
select vLoan_No as LoanNumber,dIssue_Date as Date,vParty_Id as CustomerName,dcLoan_Amt as LoanAmount, dDue_Date as DueDate from tbl_LoanMaster
WHERE dIssue_Date BETWEEN
convert(varchar,'25-jul-2013',101) and convert(varchar,'25-jul-2013',101)and vStatus='N'
Suthish NairPosted Sep 10, 2013, 8:00 AM
JAYESH AJPosted Sep 10, 2013, 6:33 AM