Re: Question on temp table
From: Paul (not_a_real_email_at_no_spam.com)
Date: 12/10/04
- Next message: Louis Davidson: "Re: ORDER BY question"
- Previous message: David Gugick: "Re: Help w/Self-Join Hierarchy Query"
- Maybe in reply to: SqlJunkies User: "Question on temp table"
- Next in thread: John Bell: "RE: Question on temp table"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Dec 2004 20:58:55 -0500
It seems you can't use table variables that way.
>From SQL Server 2000 BOL (Table Variables)
"Within its scope, a table variable may be used like a regular
table....However, table may not be used in the following statements:
INSERT INTO table_variable EXEC stored_procedure
- Next message: Louis Davidson: "Re: ORDER BY question"
- Previous message: David Gugick: "Re: Help w/Self-Join Hierarchy Query"
- Maybe in reply to: SqlJunkies User: "Question on temp table"
- Next in thread: John Bell: "RE: Question on temp table"
- Messages sorted by: [ date ] [ thread ]
