Extended stored proceders results into a temp table.

Hello,
whats the best way to search the results of running an extended stored
procedure?
Ie lets say i want to know if a folder called 'microsoft office' is under
the programs dir.
EXEC xp_dirtree 'C:\Program Files'
would a put the results into atemp table? if so how owuld you do that?
i know this does not work...
EXEC xp_dirtree 'C:\Program Files' into #temptable.
thxCREATE TABLE #t(subdirectory varchar(255), depth int)
INSERT INTO #t(subdirectory, depth)
EXEC xp_dirtree 'C:\Program Files'
SELECT * FROM #t
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jim" <zzaro@.excite.com> wrote in message news:eAqmWRqVGHA.4976@.TK2MSFTNGP11.phx.gbl...[col
or=darkred]
> Hello,
> whats the best way to search the results of running an extended stored
> procedure?
> Ie lets say i want to know if a folder called 'microsoft office' is under
> the programs dir.
> EXEC xp_dirtree 'C:\Program Files'
> would a put the results into atemp table? if so how owuld you do that?
> i know this does not work...
> EXEC xp_dirtree 'C:\Program Files' into #temptable.
> thx
>[/color]