Posted by Erland Sommarskog on 05/24/07 21:39

jknaty (kumpfjn@gmail.com) writes:
> This is great, and looks like what I'm looking for. But I tried it
> and I keep getting "Cannot access temporary tables from within a
> function". Should I create the table first and then drop it when the
> function is done?

Just change:

>> DECLARE #CourseTableTemp TABLE (

To

>> DECLARE @CourseTableTemp TABLE (

And use @CourseTableTemp throughout the function.

Logically, temp tables and table variables are very similar, but there
is some fine-print which can be really confusing.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Use CVS server with SQL Server
• Prev in forum: Re: Synchronous Bulk-Copy into two table
• Thread view: Re: SUBSTRING in User Defined Function - Invalid column

[Reply to this message]