>>>In VFP8 it works with
>>>SELECT employee_queue_schedules.cTrans_Employees_Queues_fk FROM Employee_Queue_schedules WHERE cTrans_Employees_Queues_fk in (?&vp_list)
>>>
>>>But I don't want to use macro. If I switch to SQL Server, how should I make the same select command to work?
>>
>>What is this : A view or a command query ?
>>You want execute it as a SQL Server session command or within a T-SQL program with a T-SQL variable ?
>
>I think for now I want to have local view and remote view.

Then macro parameter is the solution.