Extract second dataset from stored proc within stored proc

[Nordlund]

Hi there.
Here is something to work with...

Is there a way to extract the last dataset from sp_spaceused within a stored procedude...

Why do I have to do this you may ask...
Well, the system I've done (In delphi) does not support the use of multiple datasets.

//Nordlund

 

[Nordlund]

Like MSSQL version of getting a stored procedure's dataset into a temptable perhaps:

create table #W1 (UserName varchar(50) NULL, 
                  LongName varchar(50) NULL) 


INSERT INTO #W1(UserName, LongName) exec sp_GetUser

//Nordlund