>It looks like I can't select from a cursor in SQL Server - If I can, tell me how - so, I need to write the results of a SQL to a table in the existing database. Then I can run SQL against that. How do I do that?
Look at INSERT ... SELECT syntax (the same as in VFP, if I recall correctly).
If you need to create a new table, then you also can use INTO TABLE syntax of SELECT-SQL. The catch is to put INTO TABLE right after the FROM keyword, not after WHERE as in VFP.
If it's not broken, fix it until it is.
My Blog