two select statements in one insert statement

[q8_dreamy]

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

[sknake]

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

[q8_dreamy]

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")

[sknake]

This is the same question you asked in:
http://www.daniweb.com/forums/thread210160.html

I will respond on the original thread.

[q8_dreamy]

solved :) I put from at the end

[sknake]

Good deal

Please mark these threads as solved as you have found an answer to your question and good luck!