Non devi usare le apici per la concatenazione. Eccoti un esempio:
CREATE PROCEDURE dbo.proc_creaSQL
@EmployeeIDs nvarchar(MAX)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @sql nvarchar(MAX)
SET @sql = 'SELECT * FROM Tabella WHERE EmployeeID IN (' + @EmployeeIDs + ')'
PRINT @sql
END
exec dbo.proc_creaSQL '1,2,3,4,5'
--
Alessandro Alpi | SQL Server MVP
http://www.alessandroalpi.net
http://blogs.dotnethell.it/suxstellino
http://mvp.support.microsoft.com/profile/Alessandro.Alpi
http://italy.mvps.org