Thanks for the offical answer. :)
>You cannot use stored procedures in queries. In Sql 2000 you can use UDF's that return table data type in queries.
>
>>Im tyring to use 2 stored procedures, both returns rows, as a source in a select statement. I just want to join the results of 2 sp's. Ive been trying for a while now but I keep getting syntax errors. This is what I want to theroetically do.
>>
>>
>>select * from (countFloorCaps 'BREESE', 4) f
>> inner join (rateCapacity 'BREESE', 4) r on f.floornum = r.floornum
>>
>>
>>Any ideas, I dont want to use any temp cursors. If it cant be done, its not that big of deal, This would just save me a extra trip to my db server and a extra query inside FoxPro.
>>
>>TIA
>>
>>Eric Stephani