[SQL SERVER] Stored Procedure con parametri per tabella

[w_t]

GRANDE!

ho fatto una piccola modifica:

IF OBJECT_ID('dbo.Test') IS NOT NULL
DROP PROC dbo.Test
GO
CREATE PROC Test
	(@Tabella NVARCHAR(50))
AS
 	EXEC('SELECT * FROM ' + @Tabella)
GO

E fin qui tutto ok!

Ma se ho 2 o piu' parametri in uscita ???
es:

IF OBJECT_ID('dbo.Test') IS NOT NULL
DROP PROC dbo.Test
GO

CREATE PROC Test
	(@Tabella NVARCHAR(50))
AS
 	EXEC('SELECT * FROM ' + @Tabella) -- Parametro in uscita 1
	EXEC('SELECT COUNT(ID) AS TotCall FROM ' + @Tabella) -- Parametro in uscita 2
	EXEC('SELECT SUM(TIME_TO_SEC(TIMEDIFF(Ora_Inizio,Ora_Fine))) AS TotTime FROM ' + @Tabella) -- Parametro in uscita 3
	-- ..................................>>
	-- e cosi via .......................>>
	-- ..................................>>
GO

Grazie mille in anticipo,
poi non ti rompo piu',

ciao!