CREATE PROCEDURE sp_EquipmentDetailInquiry  

@JobNumber int,
@ItemNumber char(20),
@DateFrom datetime = Null,
@DateTo datetime = Null

as


SELECT        dbo.Batch.ReportDate as date, 
	        dbo.Item.CompanyItemId as item,
                      --dbo.EquipmentLaborEvent.RateType,
	        dbo.Equipment.CompanyEquipmentId as equipment,
             	        dbo.Equipment.Name as name, 
                     dbo.EquipmentLaborEvent.Hours as hours 
                        
FROM          dbo.EquipmentLaborEvent
			inner join dbo.Event on dbo.Event.EventGuid = dbo.EquipmentLaborEvent.EventGuid
              	  	inner join dbo.Batch on dbo.Batch.BatchGuid = dbo.Event.BatchGuid
			inner join dbo.Job on dbo.Job.JobGuid = dbo.Event.JobGuid
			inner join dbo.Item on dbo.Item.JobGuid = dbo.Job.JobGuid
			inner join dbo.Equipment on dbo.Equipment.EquipmentGuid = dbo.EquipmentLaborEvent.EquipmentGuid
WHERE              dbo.Job.CompanyJobId = @JobNumber and dbo.Item.CompanyItemId = @ItemNumber and (if @DateFrom <> Null then dbo.Batch.Reportdate >=  @DateFrom and dbo.Batch.ReportDate <= @DateTo)
ORDER BY         dbo.Batch.Reportdate, dbo.Job.CompanyJobId, dbo.Item.CompanyItemId,dbo.Equipment.CompanyEquipmentId
GO