SQL-SERVER how to run stored procedures or SELECT INTO statement in SQL paragraph

[Pankaj Bedekar <BedekarP@ALCONEMARKETING.COM>]

Title: SQL-SERVER how to run stored procedures or SELECT INTO statement in SQL paragraph

I am using MS SQL-SERVER 6.5 AND SQR 3. I need to create a table on the fly using a SELECT statement.
I tried using SELECT INTO in BEGIN-SQL ...END-SQL block but it never executed the statement.
I created a stored procedure which does the same but now I cannot execute the stored procedure using EXECUTE
or using 'BEGIN-SQL...END-SQL'

anyone have done this before ? plea let me know if anyone have more info. on this .
 
Thank you,

Pankaj