Insert Select data into Temporary Table in SQL 20122019 Community Moderator ElectionError 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
What's the "normal" opposite of flautando?
What problems would a superhuman have whose skin is constantly hot?
When traveling to Europe from North America, do I need to purchase a different power strip?
Vocabulary for giving just numbers, not a full answer
Latex does not go to next line
Are babies of evil humanoid species inherently evil?
What are some noteworthy "mic-drop" moments in math?
Intuition behind counterexample of Euler's sum of powers conjecture
Does this video of collapsing warehouse shelves show a real incident?
Error during using callback start_page_number in lualatex
NASA's RS-25 Engines shut down time
PTIJ: wiping amalek’s memory?
Why doesn't this Google Translate ad use the word "Translation" instead of "Translate"?
How can I get players to stop ignoring or overlooking the plot hooks I'm giving them?
Reversed Sudoku
Recommendation letter by significant other if you worked with them professionally?
At what distance can a bugbear, holding a reach weapon, with Polearm Mastery, get their Opportunity Attack?
How are showroom/display vehicles prepared?
How to draw cubes in a 3 dimensional plane
Is "history" a male-biased word ("his+story")?
List elements digit difference sort
PTIJ: Should I kill my computer after installing software?
Could you please stop shuffling the deck and play already?
Is "conspicuously missing" or "conspicuously" the subject of this sentence?
Insert Select data into Temporary Table in SQL 2012
2019 Community Moderator ElectionError 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
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 edited Mar 7 at 9:10
Dale Burrell
3,36842655
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
|
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 edited Mar 7 at 9:10
Dale Burrell
3,36842655
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
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 edited Mar 7 at 9:10
Dale Burrell
3,36842655
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
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 sql
sql-server edited Mar 7 at 9:10
Dale Burrell
3,36842655
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
edited Mar 7 at 9:10
Dale Burrell
3,36842655
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
edited Mar 7 at 9:10
Dale Burrell
3,36842655
edited Mar 7 at 9:10
Dale Burrell
3,36842655
edited Mar 7 at 9:10
Dale Burrell
3,36842655
3,36842655
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
asked Mar 7 at 6:26
ravishankar chavareravishankar chavare
1549
1549
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
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
Created_dt, (comma should not be here)
– SQL_M
Mar 7 at 6:30
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
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
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
@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
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
2 Answers
2
active
oldest
votes
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
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
Thanks its worked for me using common table expression
– ravishankar chavare
Mar 7 at 6:50
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.
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
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
);
);
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
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
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
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
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
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
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
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
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
answered Mar 7 at 6:36
SQL_MSQL_M
1,633617
1,633617
Thanks its worked for me using common table expression
– ravishankar chavare
Mar 7 at 6:50
add a comment |
Thanks its worked for me using common table expression
– ravishankar chavare
Mar 7 at 6:50
Thanks its worked for me using common table expression
– ravishankar chavare
Mar 7 at 6:50
Thanks its worked for me using common table expression
– ravishankar chavare
Mar 7 at 6:50
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.
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
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.
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
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.
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
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.
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
answered Mar 7 at 6:48
Rajan MishraRajan Mishra
8672823
8672823
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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