Ufdjrw

Why does a simple loop result in ASYNC_NETWORK_IO waits?

What is Cash Advance APR?

How much character growth crosses the line into breaking the character

What should you do if you miss a job interview (deliberately)?

Why is this estimator biased?

How to rewrite equation of hyperbola in standard form

Can a Canadian Travel to the USA twice, less than 180 days each time?

Why "had" in "[something] we would have made had we used [something]"?

Can a College of Swords bard use a Blade Flourish option on an opportunity attack provoked by their own Dissonant Whispers spell?

How do apertures which seem too large to physically fit work?

Electoral considerations aside, what are potential benefits, for the US, of policy changes proposed by the tweet recognizing Golan annexation?

Why would a new[] expression ever invoke a destructor?

A social experiment. What is the worst that can happen?

Can a stoichiometric mixture of oxygen and methane exist as a liquid at standard pressure and some (low) temperature?

Does the Linux kernel need a file system to run?

Does the UK parliament need to pass secondary legislation to accept the Article 50 extension

Calculate sum of polynomial roots

15% tax on $7.5k earnings. Is that right?

Unexpected behavior of the procedure `Area` on the object 'Polygon'

Is this toilet slogan correct usage of the English language?

Pre-mixing cryogenic fuels and using only one fuel tank

Mimic lecturing on blackboard, facing audience

Can disgust be a key component of horror?

Angel of Condemnation - Exile creature with second ability

Insert Select data into Temporary Table in SQL 2012

Error in sql query incorrect syntax near ')'Insert into … values ( SELECT … FROM … )How do I perform an IF…THEN in an SQL SELECT?Add a column with a default value to an existing table in SQL ServerHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerInserting multiple rows in a single SQL query?Insert results of a stored procedure into a temporary tableHow do I UPDATE from a SELECT in SQL Server?Finding duplicate values in a SQL tableFind all tables containing column with specified name - MS SQL Server

0

Question: How to Insert Complicated select data Into temp Table in sql 2012

select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type

I have Tried following solution

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type)

I got following Error

Incorrect syntax near ')'.

When I am Normally running select statement i am getting expected data

sql sql-server

share|improve this question

edited Mar 7 at 9:10

Dale Burrell

3,39052655

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Created_dt, (comma should not be here)
  
  – SQL_M
  Mar 7 at 6:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  in real query there is no comma i have edited check again
  
  – ravishankar chavare
  Mar 7 at 6:31
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So, this is "fix my code, but I'm not going to show you my code"?
  
  – Damien_The_Unbeliever
  Mar 7 at 6:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Damien_The_unbeliever why
  
  – ravishankar chavare
  Mar 7 at 6:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, so far someone's found one issue with the code, but it's with the "fake query" in the question, not the "real query" which you have actual problems with. There's an obvious extra ) at the end of your second query that isn't present in the first, but who knows whether that's relevant to your actual problem...
  
  – Damien_The_Unbeliever
  Mar 7 at 6:34
  
  

  
  
  
  

 | 
show 1 more comment

0

Question: How to Insert Complicated select data Into temp Table in sql 2012

select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type

I have Tried following solution

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type)

I got following Error

Incorrect syntax near ')'.

When I am Normally running select statement i am getting expected data

sql sql-server

share|improve this question

edited Mar 7 at 9:10

Dale Burrell

3,39052655

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Created_dt, (comma should not be here)
  
  – SQL_M
  Mar 7 at 6:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  in real query there is no comma i have edited check again
  
  – ravishankar chavare
  Mar 7 at 6:31
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So, this is "fix my code, but I'm not going to show you my code"?
  
  – Damien_The_Unbeliever
  Mar 7 at 6:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Damien_The_unbeliever why
  
  – ravishankar chavare
  Mar 7 at 6:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Well, so far someone's found one issue with the code, but it's with the "fake query" in the question, not the "real query" which you have actual problems with. There's an obvious extra ) at the end of your second query that isn't present in the first, but who knows whether that's relevant to your actual problem...
  
  – Damien_The_Unbeliever
  Mar 7 at 6:34
  
  

  
  
  
  

 | 
show 1 more comment

Question: How to Insert Complicated select data Into temp Table in sql 2012

select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type

I have Tried following solution

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type)

I got following Error

Incorrect syntax near ')'.

When I am Normally running select statement i am getting expected data

sql sql-server

share|improve this question

edited Mar 7 at 9:10

Dale Burrell

3,39052655

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type)

Incorrect syntax near ')'.

sql sql-server

sql sql-server

share|improve this question

edited Mar 7 at 9:10

Dale Burrell

3,39052655

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

share|improve this question

edited Mar 7 at 9:10

Dale Burrell

3,39052655

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

edited Mar 7 at 9:10

Dale Burrell

3,39052655

edited Mar 7 at 9:10

Dale Burrell

3,39052655

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

asked Mar 7 at 6:26

ravishankar chavareravishankar chavare

15410

2 Answers
2

active

oldest

votes

2

The following code is correct as far as syntax goes:

SELECT *
INTO #Temptable
FROM
(
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type );

Normally, you could capture the logic in a CTE and insert the CTE in your temp table.

USE SomeDB;
WITH CTE AS 
(

 SELECT *
 FROM
 (
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type )
)

INSERT INTO #T
SELECT * FROM CTE

share|improve this answer

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks its worked for me using common table expression
  
  – ravishankar chavare
  Mar 7 at 6:50
  

  
  
  
  

add a comment | 

0

The problem is, you are inserting data from an unnamed data source to a table.

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type) as tbl

Just go with this and your problem will be solved. I have just added a alias for the source you are inserting data.

share|improve this answer

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55037348%2finsert-select-data-into-temporary-table-in-sql-2012%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

The following code is correct as far as syntax goes:

SELECT *
INTO #Temptable
FROM
(
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type );

Normally, you could capture the logic in a CTE and insert the CTE in your temp table.

USE SomeDB;
WITH CTE AS 
(

 SELECT *
 FROM
 (
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type )
)

INSERT INTO #T
SELECT * FROM CTE

share|improve this answer

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks its worked for me using common table expression
  
  – ravishankar chavare
  Mar 7 at 6:50
  

  
  
  
  

add a comment | 

2

The following code is correct as far as syntax goes:

SELECT *
INTO #Temptable
FROM
(
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type );

Normally, you could capture the logic in a CTE and insert the CTE in your temp table.

USE SomeDB;
WITH CTE AS 
(

 SELECT *
 FROM
 (
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type )
)

INSERT INTO #T
SELECT * FROM CTE

share|improve this answer

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks its worked for me using common table expression
  
  – ravishankar chavare
  Mar 7 at 6:50
  

  
  
  
  

add a comment | 

The following code is correct as far as syntax goes:

SELECT *
INTO #Temptable
FROM
(
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type );

Normally, you could capture the logic in a CTE and insert the CTE in your temp table.

USE SomeDB;
WITH CTE AS 
(

 SELECT *
 FROM
 (
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type )
)

INSERT INTO #T
SELECT * FROM CTE

share|improve this answer

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

SELECT *
INTO #Temptable
FROM
(
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type );

USE SomeDB;
WITH CTE AS 
(

 SELECT *
 FROM
 (
 SELECT ROW_NUMBER() OVER(ORDER BY Ppt.Type) AS Item_Code,
 Ppt.Type AS Type,
 '11/02/19 09:51' AS Created_Dt
 FROM Product AS Psi
 INNER JOIN Db1..Items AS Ios ON Ios.Icode = Psi.Icode
 INNER JOIN Db2..Types AS Ppt ON Ppt.Type = Ios.Type )
)

INSERT INTO #T
SELECT * FROM CTE

share|improve this answer

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

answered Mar 7 at 6:36

SQL_MSQL_M

1,678718

0

The problem is, you are inserting data from an unnamed data source to a table.

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type) as tbl

Just go with this and your problem will be solved. I have just added a alias for the source you are inserting data.

share|improve this answer

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923

add a comment | 

0

The problem is, you are inserting data from an unnamed data source to a table.

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type) as tbl

Just go with this and your problem will be solved. I have just added a alias for the source you are inserting data.

share|improve this answer

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923

add a comment | 

The problem is, you are inserting data from an unnamed data source to a table.

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type) as tbl

Just go with this and your problem will be solved. I have just added a alias for the source you are inserting data.

share|improve this answer

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923

select * into #temptable from
(select ROW_NUMBER() OVER(order by ppt.type) as Item_code,
ppt.type type,
...,
...,
...,
'11/02/19 09:51' Created_dt
from product psi
inner join [DB1]..items ios on ios.icode=psi.icode
inner join [DB2]..types ppt on ppt.type=ios.type) as tbl

share|improve this answer

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923

answered Mar 7 at 6:48

Rajan MishraRajan Mishra

8672923