quote:

---

Originally posted by AAAV

so how do I do this? do i have to creat a table variable and pass it on to the SPs?

---

quote:

---

If there are three stored procedures A,B,C and
A calls B and B calls C

---

quote:

---

Originally posted by AAAV

ok...

In UP_Ownership_Total i create
CREATE TABLE [#Results_Total](
[vc_trimid] [int] NULL,
[cost_type] [nvarchar](255) NULL,
[year] [smallint] NULL,
[year_total] [decimal](10, 4) NULL,
[month1] [decimal](10, 4) NULL,
[month2] [decimal](10, 4) NULL,
[month3] [decimal](10, 4) NULL,
[month4] [decimal](10, 4) NULL,
[month5] [decimal](10, 4) NULL,
[month6] [decimal](10, 4) NULL,
[month7] [decimal](10, 4) NULL,
[month8] [decimal](10, 4) NULL,
[month9] [decimal](10, 4) NULL,
[month10] [decimal](10, 4) NULL,
[month11] [decimal](10, 4) NULL,
[month12] [decimal](10, 4) NULL,
[datetime] [smalldatetime] NULL
)

This calls UP_Fuel_cost, UP_Maintenance etc...
these calls one common procedure UP_Insert_Results which referes to #Results_Total and insert the rows for each cost

Finally comming back to UP_Ownership_Total i want to return all the rows in a select to the caller.

Now I want to know if i can refer to #results_total in UP_Insert_Results though it is created in the caller up the line UP_Ownership_total
The code is too large to post here. will this help?

---

quote:

---

Originally posted by madhivanan

No. The temporary table created inside a procedure wont available in other procedure

Madhivanan

Failing to plan is Planning to fail

---

DROP PROC myProcB
GO

CREATE PROC myProcB AS BEGIN

	INSERT #foo ([a]) VALUES (10)

END
GO

DROP PROC myProcA
GO

CREATE PROC myProcA AS BEGIN

	CREATE TABLE #foo (
		[a] INT
	)

	EXEC dbo.myProcB

	SELECT * FROM #foo
END
GO

EXEC dbo.myProcA