>>>>>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+profilesThis is not a simple problem. May be tonight I dig into my old files in regards to profile, as I remember we did have custom profile properties.
If it's not broken, fix it until it is.
My Blog