Existing Stored proc is as follows
SELECT
jobId, accountId, title, active, createdDate, updateDate, lastUpdateUser, assessmentId, templateJobPostingInfoId,
(SELECT COUNT(*) AS Expr1 FROM Posting INNER JOIN JobPostingInfo ON Posting.jobPostingInfoId = JobPostingInfo.JobPostingInfoId
WHERE (Posting.postingStatusId = 1) AND (JobPostingInfo.JobId = Job.jobId)) AS ActivePostingCount
FROM
Job
WHERE
(accountId = @accountId)