Hi,
Personly I din't like my own idea, but with dynamic sql you can have a shot-
DECLARE @COLUMNS VARCHAR(1000)
DECLARE @Col1 varchar(100), @Col2 varchar(1000)
SET @COL1 = 'DATE'
SET @COL2 = 'dateId'
SELECT @Columns = SubString (( SELECT ', ' + QUOTENAME(Column_name )
from INFORMATION_SCHEMA.columns
WHERE Table_name ='TimeDimension'
AND COLUMN_NAME != @col1
AND COLUMN_NAME != @COL2
FOR XML PATH ( '' ) ), 3, 1000)
EXEC('SELECT '+ @Columns +' FROM TimeDimension')
John Smith