CREATE PROCEDURE [dbo].[spr_ProcName]

@variableText varchar(3900) = null

AS

declare @ssql nvarchar(4000)

set @ssql = 'SELECT '

set @ssql = @ssql +' , duhColumn

set @ssql = @ssql +' FROM duhTable

set @ssql = @ssql +' where duhColumn in (''' + @PV_variableText  + ''')'

print @ssql

exec sp_executesql @ssql

END