Dynamic Tables.

hello everyone,





Thank you Darrell for your help on my "Firehose" problem.





Well, I have another question for everyone. I have three tables with the same columns: Products, Products_Sold, and Products_StandBy. I have a Stored Procedures that gets the products: Products_Get, Products_Sold_Get, and Products_StandBy_Get. I want to be able to only have one stored procedure that gets from all tables depending on what @Table variable I give it.





I tried the following, but it didn't work:








CREATE Procedure CMRC_Products_Get


@Table


AS


CREATE TABLE #TempTable


(


ProductID int,


Chest nvarchar (50),


ItemSize nvarchar (50)


)





INSERT INTO #TempTable


(


ProductID,


Chest,


ItemSize


)


SELECT


ProductID,


@Table.Chest,


CMRC_WomensSizes.ItemSize


FROM


@Table INNER JOIN


CMRC_WomensSizes ON @Table.Chest = CMRC_WomensSizes.Chest








I get an error message on the line: "@Table.Chest,"





So, my question would now be, how do I go about doing what I'm attempting here? Anybody? Thanks ahead for any help.





Sincerely,








Alec