Thursday, 4 August 2011

Date Filtering on Store Procedure

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 

No comments:

Post a Comment