Hi Gila

I found a work around, but iam facing error, the work around is

select * from OpenRowset ( 'SQLOLEDB','Server=(Local);TRUSTED_CONNECTION=YES;','Exec Temp.dbo.Software') as a

Temp.dbo.Software is the SP that returns me values

but when i tried to run this i am getting a error

Cannot process the object "Exec Temp.dbo.Software'". The OLE DB provider "SQLNCLI" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.

Does this strike any bells