>>Is it possible to call, into a SQL server stored procedure a stored procedure in a visual foxpro dbc ?
>>Thanks
>
>Can you please elaborate on your question?
>
>Do you want to invoke SQL Server SP from VFP stored procedure? I never tried, but I assume you can try standard sqlexec call.
I'll try to explain my problem:
I have a complex stored procedure in visual foxpro database.
I need to obtain the same result but using SQL server, because i have to access my fox tables from remote access.
So i have defined in a sql database some views on my fox tables using linked server.
The problem is that nonw i have to obtain data not from a simple table, but from some tables and some calculations i cannot easily remake in SQL, so i think to create a SP in my SQL server database and call a SP in visual foxpro DBC that make the elaboration and return the data i asked without making complex SP in sql server that i don't know well.......

Alternatively someone can suggest me where can i find examples on makin sp in sql server ?