use result set returned by sp as derived table

[Baihao Yuan]

Hi,

I got another question here:

I want to use query like this:

SELECT * FROM (sp_lock AS T) WHERE objectID = ...

The purpose is that I want to query the result set returned by sp_lock
using derived table, but it doesn't work. Why?

Thanks,
Baihao



--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

[David Portas]

Re: use result set returned by sp as derived table

Baihao Yuan wrote:[color=blue]
> Hi,
>
> I got another question here:
>
> I want to use query like this:
>
> SELECT * FROM (sp_lock AS T) WHERE objectID = ...
>
> The purpose is that I want to query the result set returned by sp_lock
> using derived table, but it doesn't work. Why?
>
> Thanks,
> Baihao
>[/color]

http://www.sommarskog.se/share_data.html

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:

http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx

--

[Baihao Yuan]

Re: use result set returned by sp as derived table

Thanks a lot, I really appreciate it.

Baihao


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG