asked on 9/24/2015

tsql INSERTS

Hi, I have created a temp table with 2 columns and I want to populate those 2 columns with values from the table named Question but sql does not allow me to do that. Is there any easy way to achieve this ?

Many Thanks

CREATE TABLE [#Question](
[QuestionID] int
,[NewQuestionID] int)

INSERT INTO #Question

SELECT QuestionID from Question Where Reference = 'abc', SELECT QuestionID from Question Where Reference = 'xyz'

Microsoft SQL Server 2008

Last Comment

gvamsimba

9/24/2015

ASKER CERTIFIED SOLUTION

Éric Moreau

9/24/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Jim Horn

9/24/2015

>sql does not allow me to do that
Define this, preferably with an error message, as we can't connect to your data source or run queries, so we have no idea what this means.

An alternate solution..

INSERT INTO #Question (QuestionID) 
SELECT QuestionID from Question Where Reference = 'abc'
UNION
SELECT QuestionID from Question Where Reference = 'xyz'

Open in new window

Also this implies that since I don't see column NewQuestionID in the INSERT statement, that NULL values are allowed, and you're okay with NULLs in the two rows being inserted.

Vikas Garg

9/24/2015

Hi,

If the issue is with access to the tempdb you can try using table variable in place of temp table

Declare @tbl Table(col1 int .....)

insert into @tbl
Select ......

gvamsimba

9/24/2015

ASKER

good