ALTER PROCEDURE [dbo].[dbo_iwebs_BE_GetLinkTracksAll]
@ModuleId int,
@Start as Datetime,
@End as Datetime
AS
select count(*) as TotalLinks from dbo.dbo_ iWebs_BE_LinkTracks WHERE
ModuleID=@ModuleId and
JobItemId in (
SELECT ItemId FROM dbo.dbo_iwebs_BE_Jobs where LastAccessed>=@Start and LastAccessed<@End