Create procedure [dbo].[PMP_GetPartEventReportnew]
@Event_Id int,
@Attendee_Id int,
@Fromdate datetime,
@Todate datetime
AS
Begin
select distinct e.Event_Id,ex.Amount,s.State_initials,sim.SpendItem_Name
from PMP_EventInformation e
JOIN PMP_StateMaster s ON e.Event_State_Id = s.State_Id
JOIN PMP_Expenses ex ON e.Event_Id = ex.Eventid
JOIN PMP_AttendeeInformation ea ON ex.Attendeeid = ea.Attendee_Id
JOIN PMP_SpendItemMaster sim ON ex.SpendItemid = sim.SpendItem_id
where e.Event_Id = @Event_Id and ex.Attendeeid = @Attendee_Id
and CONVERT(VARCHAR(50),ex.Date_Submitted,121) between CONVERT(VARCHAR(50),@Fromdate,121) and CONVERT(VARCHAR(50),@Todate,121)
Order By e.Event_Id
end
@Event_Id int,
@Attendee_Id int,
@Fromdate datetime,
@Todate datetime
AS
Begin
select distinct e.Event_Id,ex.Amount,s.State_initials,sim.SpendItem_Name
from PMP_EventInformation e
JOIN PMP_StateMaster s ON e.Event_State_Id = s.State_Id
JOIN PMP_Expenses ex ON e.Event_Id = ex.Eventid
JOIN PMP_AttendeeInformation ea ON ex.Attendeeid = ea.Attendee_Id
JOIN PMP_SpendItemMaster sim ON ex.SpendItemid = sim.SpendItem_id
where e.Event_Id = @Event_Id and ex.Attendeeid = @Attendee_Id
and CONVERT(VARCHAR(50),ex.Date_Submitted,121) between CONVERT(VARCHAR(50),@Fromdate,121) and CONVERT(VARCHAR(50),@Todate,121)
Order By e.Event_Id
end
No comments:
Post a Comment