>>>>I am basically doing a join of two tables (SQL-Syntax)...
>>>>
>>>>select a.*, b.*
>>>> into mydatabase.dbo.temptable
>>>> from a, b
>>>> where a.id1 = b.id1
>>>> and a.id2 = b.id2
>>>>
>>>>
>>>>If I issue this statement from within VFP, I dont get any records created in the result set, however, if I do this exact same command from within the SQL window, I get the correct 200,000 record set.
>>>>
>>>>I have even gone to the point of issuing a begin transaction/end transaction around this and still missing the boat. I even added a "checkpoint" to force all unwritten pages to be processed by SQL server but no luck...
>>>>
>>>>I am really stuck with this, any input???
>
>Are a,b really your table names? If so I've run into some "anomalies" any time the SQL alias matches those old predefined area names (A-J).
no, the real tables are
vm_work.dbo.NewActs NA, vm_work.dbo.ExactMatch EM