|
Posted by jknaty on 05/25/07 13:42
On May 24, 5:39 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Just change:
>
> >> DECLARE #CourseTableTemp TABLE (
>
> To
>
> >> DECLARE @CourseTableTemp TABLE (
>
> And use @CourseTableTemp throughout the function.
Sure enough, that worked! Thanks again for everyone's help this is
just what I needed. I do have a SP problem but I'll create a new post
for that.
>
> 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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
This is good to know, thanks!
[Back to original message]
|