thanks for the query... but both the techniques fail for sp_spaceused 🙁

in the stored proc. i added something like...

CREATE PROCEDURE dbo.Tmp_SPGetAddress

AS

begin

exec...

thanks bitbucket...

i got to know one more difference between temp tables and table variable.

option C doesn't work, it throws an error while executing in sql 2005.

Hi,

Is there any real use of such a temporary stored procedure ? can somebody please provide an example of where this can be used?

Thanks.

supplied stored proc doesn't execute successfully.

I had used this already, but this doesn't help.

the size of both the inner rectangles changes according to the data and sometimes...