此过程有一些错误帮助来解决此问题

CREATE PROCEDURE csp_GetDriverViolations 
 @nmcAccountId BIGINT
,@StartDate DATETIME
,@EndDate DATETIME
,@GroupId INT
 AS
 BEGIN
    
		SELECT * FROM dbo.DriverViolationEvent dve
				 INNER JOIN Depot dp INNER JOIN Driver dr INNER JOIN Event e 
				 ON (NMCAccount & DepotId, DriverId, CardId)
				 
				 WHERE dve.EventType=VIOLATION
				 AND dve.Clock in (DRIVING, ONDUTY, CUMULATIVE)
				 AND dve.NCMAccount=@nmcAccountId
				 AND dve.EventTime=e.TimeDate
			     AND dve.EventTime BETWEEN @StartDate AND @EndDate

END