DECLARE @GblTableName NVARCHAR(300)

SET @GblTableName = '[tempdb].[dbo].[Temp' + REPLACE(CAST(NEWID() AS NVARCHAR(50)), '-', '') + ']'

EXEC ('IF OBJECT_ID(''' + @GblTableName + ''') IS NOT NULL

DROP TABLE ' + @GblTableName + '')

exec('CREATE TABLE ' + @GblTableName + '

(

UserID NVARCHAR(100) ,

ProductID NVARCHAR(100) ,

Price NVARCHAR(100) ,

ProductQty NVARCHAR(100) ,

TotalPrice NVARCHAR(100) ,

ReportPrice NVARCHAR(100)

)')

SET @ExecuteSql = N'INSERT INTO ' + @GblTableName + ' SELECT UserID ,ProductID ,Price,ProductQty,TotalPrice,ReportPrice

FROM ( SELECT USERID ,

PRODUCTID ,

PRICE ,

PRODUCTQTY ,

TOTALPRICE ,

REPORTPRICE ,

DATAORDER

FROM ABC) T '

EXEC (@ExecuteSql)