>>>>With VFP I can select into a cursor (temporary table) and then manipulate that cursor to create the data I need for a report. Is there a similar technique when working with .NET and SQL Server? I have seen select into table but not anything similar to the VFP cursor.
>>>>Thanks
>>>
>>>In SQL Server you can select into temporary table (table in the tempdb database) using into #TableName syntax. # before name indicates that it's a local temp table.
>>
>>
>>Thanks Naomi. How do you release the temporary table?
>
>It is automatically closed once connection that created that table closes. Or you can also use
>
>IF object_id('tempdb..#TempName','U') IS NOT NULL drop table #TempName

Thanks again. UT is the best! Can you help me with this one?
http://forums.asp.net/t/1715921.aspx/1?Problem+with+profiles