>>>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
If it's not broken, fix it until it is.
My Blog