CREATE Proc usersbyLocation(@locids varchar(max)=NULL)

AS

BEGIN

Declare @STR varchar(max)

SET @STR='SELECTUserID,

UserForename,

UserSurname,

LocationName

fromtUser JOIN

tLocation on tUser.locationID=tLocation.LocationID

Where tLocation.LocationID in ('+@locids+')'

PRINT @locids

Exec (@str)

END

--Test

--Exec usersbyLocation '1,2,3,4,5,6'