MS SQL

MS SQL RSS

two select statements in one insert statement

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Apr 2008

Posts: 38

Reputation: q8_dreamy is an unknown quantity at this point

Solved Threads: 0

q8_dreamy

Offline

Light Poster

two select statements in one insert statement

Aug 10th, 2009

hiiii how can I use 2 different select statement to insert 2 different values in same insert statement ????

•

Join Date: Feb 2009

Posts: 3,187

Reputation: sknake has much to be proud of

Solved Threads: 571

sknake

Offline

.NET Enthusiast

Re: two select statements in one insert statement

Aug 10th, 2009

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
IF OBJECT_ID('TestTable', 'U') IS NOT NULL DROP TABLE TestTable
CREATE TABLE TestTable
(
  Col1 VARCHAR(30),
  Col2 VARCHAR(30)
)
INSERT INTO TestTable (Col1, Col2) VALUES ('a', 'b')
GO
 
IF OBJECT_ID('tempdb..#Temp', 'U') IS NOT NULL DROP TABLE #Temp
CREATE TABLE #Temp
(
  Col1 VARCHAR(30),
  Col2 VARCHAR(30)
)
 
GO 
 
--Now we have our test data setup
 
INSERT INTO #Temp (Col1, Col2)
SELECT
(SELECT Top 1 Col1 FROM TestTable) As Col1,
(SELECT Top 1 Col2 FROM TestTable) As Col2
 
SELECT *
FROM #Temp
IF OBJECT_ID('TestTable', 'U') IS NOT NULL DROP TABLE TestTable
Create Table TestTable
(
  Col1 varchar(30),
  Col2 varchar(30)
)
Insert Into TestTable (Col1, Col2) Values ('a', 'b')
GO

IF OBJECT_ID('tempdb..#Temp', 'U') IS NOT NULL DROP TABLE #Temp
Create Table #Temp
(
  Col1 varchar(30),
  Col2 varchar(30)
)

GO 

--Now we have our test data setup

Insert Into #Temp (Col1, Col2)
Select
(Select Top 1 Col1 From TestTable) As Col1,
(Select Top 1 Col2 From TestTable) As Col2

Select *
From #Temp

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Apr 2008

Posts: 38

Reputation: q8_dreamy is an unknown quantity at this point

Solved Threads: 0

q8_dreamy

Offline

Light Poster

Re: two select statements in one insert statement

Aug 10th, 2009

I got unspecified error
this is my code:

("insert into Results (cnt, a_q1) select(select count (*) from Answers) as cnt, (select count(*) from Answers where answer_q1='ضعيف')as a_q1")