RE: Stored Procedure & User Table
You have to name your temp.table with prefix '# ' like #aarobtmp: CREATE PROCEDURE rob_tmp_1 AS SELECT glt_urn, glt_code, glt_description INTO #aarobtmp FROM ncm_general_list_type SELECT * FROM #aarobtmp GO
2002-04-16