Question...

Many of our current VFP queries utilize macro-expansion heavily....we have many instances of...

SELECT &cFldList FROM &cFileList WHERE &cJoin GROUP BY &cGroup

We'd like to convert some of these to Stored Procs in SQL Server, and then use SQLEXEC from VFP to call them. However, I haven't been able to figure out the syntax in T-SQL. I'm interested in all the parameters (field list, file list, join clause, and group by), but specifically the group by...basically, having it be variable at runtime.

Can this be done?

Thanks,
Kevin