Viewing 3 posts - 1 through 3 (of 3 total)
my solution is:
DECLARE @stringa nvarchar(4000) @parametri nvarchar(100)
DECLARE @punteggioSel smallint, @punteggioTot
SET CONCAT_NULL_YIELDS_NULL OFF
SET @stringa = @stringa + ' SELECT @punteggioInt = @punteggioInt + PuntiMaschio from ' + @TblEta + '...
August 30, 2001 at 2:46 am
I have solved my problem with sp_executesql.
Thank you for yuor help
August 29, 2001 at 8:35 am
yes, it'good but how can I read the value of variable @punteggio?
SET @VAREXEC = 'SELECT @punteggio = punti from '+ @TblProfessione + 'WHERE ID = 1'
EXEC (@VAREXEC)
@somma = @punteggio +...
August 28, 2001 at 10:07 am
Viewing 3 posts - 1 through 3 (of 3 total)