How do i pass a table variable or temp table as a input paramenter to a stored procedure????? HELP!

You can do that by using #temp_table which will be accessible throw the called store procedures and functions for current session. Note: will be better to drop the table at the end of your work.

example using Northwind DB:
CREATE PROCEDURE Test_GetTempData
 -- Add the parameters for the stored procedure here
AS
BEGIN

 Select * from #temp_Table
END
CREATE TABLE #temp_Table(
 [CustomerID] nchar(5) ,
 [CompanyName] nvarchar(40)
)

insert into #temp_Table(CustomerID, CompanyName)
select [CustomerID], [CompanyName] from customers

EXEC [dbo].[Test_GetTempData]

drop table #temp_Table

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team

The question has been closed.

The Quomon Team