question

I found a what seems to be a really nice stored procedure. However, I'm getting an error when I try to use it. Maybe someone can help me understand all the parameters I have to supply. Please see the my query and the error following this stored procedure. CREATE PROCEDURE [dbo].[crosstab] @select varchar(8000), @sumfunc varchar(100), @pivot varchar(100), @table varchar(100), @where varchar(1000)='1=1' 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 ' + @where + ' AND ' + @pivot + ' Is Not Null') SELECT @sql='', @sumfunc=stuff(@sumfunc, len(@sumfunc), 1, ' END)' ) 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) + ''' = ' + 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) SET ANSI_WARNINGS ON Here's my query: EXECUTE crosstab 'SELECT PHYS_COUNT_TAG.PHYS_COUNT_ID, PHYS_COUNT_TAG.TAG_NO, PHYS_COUNT_TAG.TRACE_ID, PHYS_COUNT_TAG.PART_ID, PHYS_COUNT_TAG.COUNT_QTY INVENTORY_TRANS.[TYPE], INVENTORY_TRANS.CLASS, INVENTORY_TRANS.QTY INVENTORY_TRANS.ACT_MATERIAL_COST from PHYS_COUNT_TAG inner join INVENTORY_TRANS on (PHYS_COUNT.PART_ID = INVENTORY_TRANS.PART_ID) group by PHYS_COUNT_TAG.PHYS_COUNT_ID', 'INVENTORY_TRANS.[TYPE], INVENTORY_TRANS.CLASS, sum(INVENTORY_TRANS.QTY)' This is my error: Msg 201, Level 16, State 4, Procedure crosstab, Line 0 Procedure or function 'crosstab' expects parameter '@pivot', which was not supplied.