LINE

SELECT @CMD = 'SELECT * INTO ##TEMP_TABLE FROM

FAILS when column type is money - --@FLD)

"IMPLICIT CONVERSION FROM DATA TYPE MONEY TO VARCHAR IS NOT ALLOWED. USE THE CONVERT FUNCTION TO RUN THIS QUERY."

No success either with this code:

SET @CMD = 'SELECT ' + @fld + ' AS [FldNam]

INTO ##TMPTBL1

FROM ##TEMP_TABLE

WHERE TAB_ID_MARKER = ' + CONVERT(VARCHAR(10), @COUNTER)

EXEC SP_EXECUTESQL @CMD OUTPUT

IF @TYPE = 'money'

SELECT CONVERT(varchar(10), FldNam) FROM ##TMPTBL1

ELSE

SELECT FldNam FROM ##TMPTBL1.

" Invalid column name 'FldNam' "

Suggestions ?