SQL Puzzle | The SINGLE INSERT Puzzle / The Double INTO Puzzle | SQL Interview Question

In this puzzle you have to get first record from FirstTab table i.e. 1 and insert that record into table SecondTab and ThirdTab with a single INSERT keyword. Basically you cannot use Multiple INSERT statements. This was asked to one of my developers by a customer in a technical interview. Please see the sample input data and the expected output.

Sample Input

Table1 – FirstTab

Table2 – SecondTab

Table3 – ThirdTab

Expected Output

Table2 – SecondTab

Table3 – ThirdTab

Script – DDL and INSERT Sample Data

--

CREATE TABLE FirstTab
(
	Id INT
)
GO

INSERT INTO FirstTab VALUES (1),(2)
GO

CREATE TABLE SecondTab
(
	Id INT
)
GO

CREATE TABLE ThirdTab
(
	Id INT
)
GO

--

SOLUTION 1

--

INSERT INTO SecondTab
OUTPUT inserted.Id INTO ThirdTab
SELECT Id FROM FirstTab
WHERE Id = 1

--

OUTPUT – 1

--

---Data from the SecondTab and ThirdTab

Id
-----------
1

(1 row affected)

Id
-----------
1

(1 row affected)

--

Enjoy 🙂

Please add comment(s) if you have one or multiple solutions in mind. Thank You.

Pawan Khowal

Pawan is a SQL Server Developer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go throgh the top pages from his blog.

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com