Can you select from a Derived table calling a stored proc?

From: we7313 (we7313_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 09:23:02 -0800

I know the sql is incorrect on this but was wondering if something like this
was possible:

select * from
(
exec storedProc1 'value1'
) a 

-- 
will

Relevant Pages

  • MSSQL Install fails again & again & ....
    ... I installed MDAC 2.8 and them re-attempted the SQL ... >using a different instance name to the previous install, ... >The physical file name 'C:\Program Files\Microsoft SQL ... >Server\MSSQL\DATA\msdbdata.mdf' may be incorrect. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL INSERT statement in VBA
    ... You can't use VBA variables in a SQL statement. ... Dim Value1 As Long ... Dim Value2 As String ...
    (microsoft.public.access.queries)
  • Re: Query Tuning Help - Sum multiple columns
    ... The table has 171,000 rows, but the query takes 20 minutes to ... Something does not look right with your SQL statement - you alias ... SUMas VALUE1 and then include VALUE1 in the GROUP BY ... Now, retrieve the execution plan: ...
    (comp.databases.oracle.server)
  • Re: Select * From clause
    ... > Is this incorrect? ... ON" syntax was indeed introduced in ANSI SQL -92. ... the "old syntax" is fully allowed in ANSI SQL-92 and thereafter. ...
    (microsoft.public.sqlserver.programming)
  • Re: Secret to getting a response?
    ... so I can't say why you are experiencing it. ... Or are any of the SQL 2000 fields ... Are you positive that your ODBC links point to the same SQL database as you ... that my SQL Server 2000 ODBC links are returning incorrect data. ...
    (microsoft.public.access.queries)