MS SQL Server - requete SQL select d'une SP

Author

requete SQL select d'une SP

Ch.

2006-02-03, 7:23 am

Comment faire ce genre de requete ?

select top(10) T.*
from ( exec SEL_MODELES 767 ) T
WHERE T.ID > 50

John Bell

2006-02-04, 11:23 am

Que SEL_MODELES fait-il ?
Étudiez
http://msdn.microsoft.com/library/d...create_7r1l.asp
John

"Ch." <christophe@ipnet.fr> wrote in message
news:uwQLEJMKGHA.3164@TK2MSFTNGP11.phx.gbl...
> Comment faire ce genre de requete ?
>
> select top(10) T.*
> from ( exec SEL_MODELES 767 ) T
> WHERE T.ID > 50
>
>

Hugo Kornelis

2006-02-05, 8:23 pm

On Fri, 3 Feb 2006 14:03:44 +0100, Ch. wrote:

>Comment faire ce genre de requete ?
>
>select top(10) T.*
>from ( exec SEL_MODELES 767 ) T
>WHERE T.ID > 50
>

Hi Ch.,

CREATE TABLE #T
(Column1 .... ,
Column2 .... ,
...)
go
INSERT INTO #T (Column1, Column2, ...)
EXEC SEL_MODELES 767
--
SELECT TOP (10) *
FROM #T
WHERE ID > 50
ORDER BY ....
go
DROP TABLE #T
go

Pour l'aide en Français, tu peus aller meilleure vers
microsoft.public.fr.sqlserver.

--
Hugo Kornelis, SQL Server MVP

Sponsored Links