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 ?
CREATE TABLE [#Question](
INSERT INTO #Question
SELECT QuestionID from Question Where Reference = 'abc', SELECT QuestionID from Question Where Reference = 'xyz'