***********************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
Loading
Ravi ShekharPosted Aug 5, 2013, 12:29 AM
Amit TiwariPosted Aug 3, 2013, 10:45 AM
venkata kumarPosted Aug 3, 2013, 5:27 AM
try the fallowing procedure
i done some changes
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=dateadd(mm,12,@dtF) and vStatus='N'
end
Ravi ShekharPosted Aug 3, 2013, 4:56 AM
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=dateadd(YEAR ,+1,@dtF) and vStatus='N'
end
Ravi ShekharPosted Aug 3, 2013, 4:53 AM
Iftikar HussainPosted Aug 3, 2013, 3:20 AM
What is the issue? Can you explain more?
Regards,
Iftikar