@Keyword nvarchar(500),
@Location nvarchar(500))
as
select  distinct j.jobid,
		 j.jobtitle,
		 convert(varchar(11),j.createdon, 106) as date,
		 a.description as 'location',
		 left(cast(j.publishedjobdescription as Nvarchar(500)), 300)+ ' ....' as 'Description',
		 j.createdon,
		 cast(round((j.maxbasic),2,1) as decimal(10))as 'salary'
FROM ATTRIBUTES A
		INNER JOIN JOBATTRIBUTES JA ON A.ATTRIBUTEID = JA.ATTRIBUTEID
		INNER JOIN JOBS J ON JA.JOBID = J.JOBID
			

where a.description  like '%'+@Location+'%'  
	  and (j.jobtitle like '%'+@keyword+'%'or  publishedjobdescription  like '%'+@keyword+'%')
	  and a.attributemasterid = '419'
	  and j.updatedon > dateadd(month,-6,getdate()) 
	  and DATALENGTH(publishedjobdescription) > 100 
	  and archived = 'n'
	  and published = 'y'

order by j.createdon desc

CREATE PROCEDURE YourProc
(
    @Keyword nvarchar(500)
    ,@Location nvarchar(500)
)
AS

SET NOCOUNT ON

;WITH JobLocations (JobId, Location)
AS
(
    SELECT JA.JobId
        ,A.[Description]
    FROM Attributes A
        JOIN JobAttributes JA
            ON A.AttributeId = JA.AttributeId
    WHERE A.AttributeMasterId = 419
)
SELECT
    J.jobid
    ,J.jobtitle
    ,CONVERT(varchar(11), J.CreatedOn, 106) as [Date]
    ,D.Locations
    ,SUBSTRING(J.PublishedJobDescription, 1, 300) + ' ....' as [Description]
    ,J.CreatedOn
    ,CAST(ROUND((J.MaxBasic),2,1) as decimal(10)) as Salary
FROM Jobs J
    JOIN
    (
        SELECT JobId
            ,STUFF
            (
                (
                    SELECT ' ' + Location + ','
                    FROM JobLocations JL1
                    WHERE JL1.JobId = JL.JobId
                    FOR XML PATH('')
                 )
                ,1 ,1 ,''
            ) AS Locations
        FROM JobLocations JL
        GROUP BY JobId
    ) D
        ON J.JobId = D.JobId
WHERE J.UpdatedOn > DATEADD(m, -6, GETDATE())
    AND
    (
        J.JobTitle LIKE '%' + @keyword + '%'
        OR J.PublishedJobDescription LIKE '%' + @keyword + '%'
    )
    AND J.Archived = 'N'
    AND J.Published = 'Y'
    AND D.Locations LIKE '%' + @Location + '%'
ORDER BY J.CreatedOn DESC
GO