spJobPosts

    CREATE  PROCEDURE dbo.spJobPosts
    (
        @JobBoardID int
    )
    AS
        select JobPosts.ID,ProfessionCodes.Code as ProfessionCode,JobPosts.Title,
        JobPosts.Description,JobPosts.SalaryMin,JobPosts.SalaryMax,
        JobPosts.CompanyName,JobPosts.Division,JobPosts.City,
        JobPosts.State,JobPosts.Country,JobPosts.County,JobPosts.EMail,JobPosts.URL,
        JobPosts.AdditionalInfo,JobPosts.Guid,JobPosts.PostedByID,
        dbo.fnUserName(JobPosts.PostedByID) as [FullName],
        JobPosts.ShowMyInfo,JobPosts.JobBoardID,JobPosts.Approved,
        JobPosts.HideCompanyInfo, JobPosts.PostedOn, JobPosts.ProfessionCodeID
        from [dbo].JobPosts
        inner join [dbo].ProfessionCodes on ProfessionCodes.ID = JobPosts.ProfessionCodeID
        where JobPosts.JobBoardID = @JobBoardID
        order by JobPosts.PostedOn
    RETURN