Creating temp tables in RS

How do I create a simple temp table in RS.SELECT ProductID, Name, StandardCost
INTO #MyProd
FROM Product
GO
SELECT * FROM #MyProd
"Susan" <Susan@.discussions.microsoft.com> wrote in message
news:17C238A5-04F5-40F7-9585-DF47A9B171D5@.microsoft.com...
> How do I create a simple temp table in RS.|||use a stored procedure to create and then select from the temp table.
Paul Turley wrote:
> SELECT ProductID, Name, StandardCost
> INTO #MyProd
> FROM Product
> GO
> SELECT * FROM #MyProd
>
> "Susan" <Susan@.discussions.microsoft.com> wrote in message
> news:17C238A5-04F5-40F7-9585-DF47A9B171D5@.microsoft.com...
> > How do I create a simple temp table in RS.|||Unfortunately RS gives me an error for the use of #.
"Paul Turley" wrote:
> SELECT ProductID, Name, StandardCost
> INTO #MyProd
> FROM Product
> GO
> SELECT * FROM #MyProd
>
> "Susan" <Susan@.discussions.microsoft.com> wrote in message
> news:17C238A5-04F5-40F7-9585-DF47A9B171D5@.microsoft.com...
> > How do I create a simple temp table in RS.
>
>