Posted by Dilbert on 10/01/49 11:30

Nevermind, It seemed to work the second time i tried to run the query
in reporting services.

BEGIN

CREATE TABLE #temptbl2
(
Enddate VARCHAR(50),
ProjectNumber VARCHAR(50),
ProjectManager VARCHAR(50),
resourceManager VARCHAR(50),
CostCentre VARCHAR(50),
WorkInProgress FLOAT
)

INSERT INTO #temptbl2
EXECUTE jmpwipreportbasic '09/09/2009'

SELECT DISTINCT costcentre FROM #temptbl2


DROP TABLE #temptbl2


END

Maybe this will help someone else.

[Back to original message]