no je to uplna prasacina. ked tak elegantnejsie riesenie bez nutnosti kopirovat tabulku je taketo :)

DECLARE @FIELDS NVARCHAR(MAX), @CMD NVARCHAR(MAX)
SET @FIELDS = ''
SELECT @FIELDS = @FIELDS + c.name + ','
FROM sys.columns c
INNER JOIN sys.tables t
	on t.object_id = c.object_id
WHERE t.name = 'Tvoja_tabulka' and c.name not in ('vynechane_pole1', 'vynechane_pole2')

set @CMD = 'SELECT ' + left(@FIELDS, LEN(@FIELDS) - 1) + ' FROM Tvoja_tabulka'

exec (@CMD)