That what openquery is for. You can send pass-through query to the specified linked server. Fox is in my case.
Problem is to build a complete string with parameters. Too many quotes.


>>>>>>>>Has someone come up with any kind of automation tool to build these sql strings with 1000000000000 number of single quotes?
>>>>>>>
>>>>>>>What strings are you referring to and what is the problem?
>>>>>> Something like this:
>>>>>>
>>>>>>declare @sql_str char (4000)
>>>>>>set @sql_str =
>>>>>>'select * from openquery(VAMCPD,
>>>>>>''select a.cItemno,a.nShipQty,a.nSalesAmt-a.nDiscAmt as Amt
>>>>>> from aritrs a
>>>>>>inner join arinvc b on a.cInvNo=b.cInvNo
>>>>>>where a.cCustno+a.cInvNo like ''' + '''59002' + '%''' + ''' and cType= '''''
>>>>>>+ ''''''')'
>>>>>>--select @sql_str
>>>>>>exec (@sql_str)
>>>>>>
>>>>>>it took just a couple hours, or even more. I am trying to add more parameters to a query and it is a nightmare.
>>>>>
>>>>>Sorry but I still do not understand what you're doing and where. Do you build the string in VFP or in SQL Server stored procedure? Where parameters comes from and how?
>>>>
>>>>I am going to have a SQL SP to run this code. Parameters will be sent into that procedure.
>>>>The problem is building correct SQL string with all these quotes.
>>>
>>>Why you need Dynamic SQL ?
>>Do you know another way of running non-SQL code from SQL Server?
>
>
>
>You can't run non-SQL code in SQL Server no matter what you try:
>

>select * from openquery(VAMCPD,'select a.cItemno,a.nShipQty,a.nSalesAmt-a.nDiscAmt as Amt
>                                       from aritrs a
>                                inner join arinvc b on a.cInvNo=b.cInvNo
>                                where a.cCustno+a.cInvNo like '''59002%''' and cType= ''''')
>
>