Another observation: The join between the contractskill and users tables is missing from the stored procedure code posted -

"FROM DBO.contractskill

INNER JOIN DBO.users

INNER JOIN DBO.contract

ON DBO.users.userid = DBO.contract.userid"