Hi to all,

I want to create a table within a stored proc from an existing table.
I am using a 'Select Into' query to achieve this.
The problem is that the name of new table will be decided at the runtime ( through an input parameter) If i give variable name at the place of table name in the Select Into query , my procedure doesn't get compiled.

Something like this

************************************************** ***********
 select * into @tbName from @BIGTABLE where sno>=@fromSno and sno<=@toSno
************************************************** ************

Both @BIGTABLE and @tbName are input parameters of type varchar

Please help

Anubhav Kumar

__________________
Anubhav Kumar
http://anubhavtimepass.blogspot.com/

CREATE PROCEDURE Testing123
@FROMTableName varchar(50),
@ToTableName varchar(50)
AS
BEGIN

DECLARE @SQL nVarchar(1000)
SET @SQL = 'SELECT * INTO ' + @ToTableName + ' FROM ' + @FromTableName
exec sp_executesql @SQL

END

--execute this procedure
exec Testing123 @FROMTableName='Customer', @ToTableName='newtable'

Thanks a lot. it was needed urgently

Anubhav Kumar