I would like to call this stored procedure, but I am unable to pass
parameters to the @Start and @End.
Is thier a way to pass parameters to a pass through query from MS
Access?
SELECT COUNT(dbo.tblPe rsActionHistory .PersActionID) AS [Total Ct],
[dbo].fn_FindStartPa yPeriod(dbo.tbl PersActionHisto ry.PersActionID , 2)
AS [Signed PP]
FROM dbo.tblPersActi onLog INNER JOIN
dbo.tblPersActi onHistory ON
dbo.tblPersActi onLog.PersActio nID =
dbo.tblPersActi onHistory.PersA ctionID
WHERE (dbo.tblPersAct ionLog.StatusID BETWEEN 4 AND 7) AND
(dbo.tblPersAct ionLog.Rejected = 0) AND
(dbo.tblPersAct ionLog.IsPayAct ion = 0) AND
(dbo.tblPersAct ionHistory.Acti onTypeID = 5) AND
(dbo.fn_IsParAC orrection(dbo.t blPersActionHis tory.PersAction ID) = 0)
AND
([dbo].fn_ParNotExcep tion(dbo.tblPer sActionHistory. PersActionID) = 1)
AND (dbo.tblPersAct ionHistory.Item DTG >= @StartDate) AND
(dbo.tblPersAct ionHistory.Item DTG <= @EndDate)
GROUP BY
[dbo].fn_FindStartPa yPeriod(dbo.tbl PersActionHisto ry.PersActionID , 2)