>>>>>>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?