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 ?