Statement 'SELECT INTO' is not supported in this version of SQL Server - SQL Azure

Question

I am getting Statement 'SELECT INTO' is not supported in this version of SQL Server in SQL Server for the below query inside stored procedure ``` DECLARE @sql NVARCHAR(MAX) ,@sqlSelect NVARCHAR(MAX) = '' ,@sqlFrom NVARCHAR(MAX) = '' ,@sqlTempTable NVARCHAR(MAX) = '#itemSearch' ,@sqlInto NVARCHAR(MAX) = '' ,@params NVARCHAR(MAX) SET @sqlSelect ='SELECT ,IT.ITEMNR ,IT.USERNR ,IT.ShopNR ,IT.ITEMID' SET @sqlFrom =' FROM dbo.ITEM AS IT' SET @sqlInto = ' INTO ' + @sqlTempTable + ' '; IF (@cityId > 0) BEGIN SET @sqlFrom = @sqlFrom + ' INNER JOIN dbo.CITY AS CI2 ON CI2.CITYID = @cityId' SET @sqlSelect = @sqlSelect + 'CI2.LATITUDE AS CITYLATITUDE ,CI2.LONGITUDE AS CITYLONGITUDE' END SELECT @params =N'@cityId int ' SET @sql = @sqlSelect +@sqlInto +@sqlFrom EXEC sp_executesql @sql,@params ``` I have around 50,000 records, so decided to use Temp Table. But surprised to see this error. How can i achieve the same in SQL Azure? Edit: Reading this blog http://blogs.msdn.com/b/sqlazure/archive/2010/05…

Accepted Answer

`SELECT INTO` is one of the many things that you can unfortunately not perform in SQL Azure.

What you'd have to do is first create the temporary table, then perform the insert. Something like:

```
CREATE TABLE #itemSearch (ITEMNR INT, USERNR INT, IT.ShopNR INT, IT.ITEMID INT)
INSERT INTO #itemSearch
SELECT IT.ITEMNR, IT.USERNR, IT.ShopNR ,IT.ITEMID                  
FROM dbo.ITEM AS IT
```

Statement 'SELECT INTO' is not supported in this version of SQL Server - SQL Azure

Solution

Problem

Related problems