Hi!

For SQL Server 7.0, in the stored procedure you can do following:

declare @SQL1 as varchar(8000), @SQL2 as varchar(8000), @SQL3 as varchar(8000), @SQL4 as varchar(8000)
select @SQL1 = "SELECT " + @paramFieldsList
select @SQL2 = " FROM " + @paramFileList
select @SQL3 = " WHERE " + @paramJoinANDFilters
select @SQL4 = " GROUP BY " + @paramGroup

EXECUTE (@SQL1+@SQL2+@SQL3+@SQL4)


In the VFP you can run SQL Server Select command built in the string using SQLEXEC() command:

cSQL = "SELECT " + ....
nResult = SQLEXEC(CursorGetProp("ConnectHandle","SomeMyViewAlias"),cSQL,"ResultAliasName")

HTH.

>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