cfstoredproc fails yet SP runs in QA

ok I'm stumped...

I've got a SP I found which I've modified slightly that dynamically creates a pseudo-crosstab


The Procedure is

------------------------------------------------------------
CREATE PROCEDURE crosstab
@select varchar(8000),
@sumfunc varchar(100),
@pivot varchar(100),
@table varchar(100)
AS

DECLARE @sql varchar(8000), @delim varchar(1)
SET NOCOUNT ON
SET ANSI_WARNINGS OFF

EXEC ('SELECT ' + @pivot + ' AS pivot INTO ##pivot FROM ' + @table + ' WHERE 1=2')
EXEC ('INSERT INTO ##pivot SELECT DISTINCT ' + @pivot + ' FROM ' + @table + ' WHERE '
+ @pivot + ' Is Not Null')

SELECT @sql='',  @sumfunc=stuff(@sumfunc, len(@sumfunc), 1, ' END ),0)' )


SELECT @delim=CASE Sign( CharIndex('char', data_type)+CharIndex('date', data_type) )
WHEN 0 THEN '' ELSE '''' END
 
FROM tempdb.information_schema.columns
WHERE table_name='##pivot' AND column_name='pivot'

SELECT @sql=@sql + '''' + convert(varchar(100), pivot) + ''' = ' +
'isnull(' + stuff(@sumfunc,charindex( '(', @sumfunc )+1, 0, ' CASE ' + @pivot + ' WHEN '
+ @delim + convert(varchar(100), pivot) + @delim + ' THEN ' ) + ', ' FROM ##pivot

DROP TABLE ##pivot

SELECT @sql=left(@sql, len(@sql)-1)
SELECT @select=stuff(@select, charindex(' FROM ', @select)+1, 0, ', ' + @sql + ' ')
EXEC (@select)
------------------------------------------------------------

The statement it creates is

select ProductIDUPC ,
'669' = isnull(sum( CASE OrderID WHEN 167669 THEN qty END ),0),
'981' = isnull(sum( CASE OrderID WHEN 167981 THEN qty END ),0),
'135' = isnull(sum( CASE OrderID WHEN 168135 THEN qty END ),0),
'686' = isnull(sum( CASE OrderID WHEN 168686 THEN qty END ),0),
'022' = isnull(sum( CASE OrderID WHEN 169022 THEN qty END ),0)
from vwDistributorProductionForecast
group by ProductIDUPC Order By ProductIDUPC asc

The SP runs fine in query Analyzer and give the expected results
                      669     981   135    686    022
92013300249      0      76      0      38      38
92013300307      0       0      0      19      0
92013300321      19      0      0      76      0
92013300362      0      0      0      61      0
92013300364      19      0      0      57      0

(i've modified the orderids for readablity)

If I manually copy the select query it runs fine in cf

but when I call the SP using cfstoredproc

<cfstoredproc datasource="Mydata" procedure="crosstab"
                    debug="yes"
                  returncode="0">

<cfprocparam type = "IN"
  variable = "select"
  value = "select ProductIDUPC from vwDistributorProductionForecast group by ProductIDUPC Order By ProductIDUPC asc"
  CFSQLType = "CF_SQL_VARCHAR"
  maxLength = "8000"
   null = "No">

<cfprocparam type = "IN"
  variable = "sumfunc"
  value = "sum(qty)"
  CFSQLType = "CF_SQL_VARCHAR"
  maxLength = "100"
   null = "No">

<cfprocparam type = "IN"
  variable = "pivot"
  value = "OrderID"
  CFSQLType = "CF_SQL_VARCHAR"
  maxLength = "100"
   null = "No">

<cfprocparam type = "IN"
  variable = "table"
  value = "vwDistributorProductionForecast"
  CFSQLType = "CF_SQL_VARCHAR"
  maxLength = "1000"
   null = "No">

<cfprocresult name = spResults>
</cfstoredproc>


I get the error

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'END'.

Any ideas as to what is going on here...this SHOULD work