При создании sqladapter в wizarde в VS2003 С# SQL SERVER 2000 при использовании следующей stored procedure при указании этой процедуры в select выдает ошибку Generated select statment invalid object name #temp. На самом SQL Server процедура работает отлично. В чем причина и как с этим бороться? Заранее благодарен!!!

CREATE PROCEDURE VladCDMAReport AS
BEGIN
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET NOCOUNT ON
create table #temp (DT datetime,CF1 real,CF2 real,CF3 real,CF4 real,CF5 real,CF6 real,CF7 real,CF8 real)

INSERT INTO #temp
SELECT DISTINCT DATEIN,0,0,0,0,0,0,0,0 from sdaystattraf where datein>'01.01.2009'

UPDATE #temp
SET cf1=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=9326 and ID_PARAMETER=1400 and HOURSCOUNT!=0
UPDATE #temp
SET cf2=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=9330 and ID_PARAMETER=1400 and HOURSCOUNT!=0
UPDATE #temp
SET cf3=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=9326 and ID_PARAMETER=1404 and HOURSCOUNT!=0
UPDATE #temp
SET cf4=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=9330 and ID_PARAMETER=1404 and HOURSCOUNT!=0
UPDATE #temp
SET cf5=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=14619 and ID_PARAMETER=1435 and HOURSCOUNT!=0
UPDATE #temp
SET cf6=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=14623 and ID_PARAMETER=1435 and HOURSCOUNT!=0
UPDATE #temp
SET cf7=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=14619 and ID_PARAMETER=1438 and HOURSCOUNT!=0
UPDATE #temp
SET cf8=PARAMVALUE/HOURSCOUNT FROM SDAYSTATTRAF a
WHERE dt=a.DATEIN and dt>'01.02.2009' and ID_OBJECT=14623 and ID_PARAMETER=1438 and HOURSCOUNT!=0


select * from #temp
SET NOCOUNT OFF
DROP table #temp
END
GO