Title: Insert Multiple Rows into Table with Union ALL                                 If you need copy same format use firefox or chrome or safari but iexplorer not work


Preview of Code
-- Check and Drop Existing Temp Table
IF EXISTS(SELECT 1 FROM tempdb.dbo.sysobjects WHERE ID = OBJECT_ID(N`tempdb..#tempTable`))
          DROP TABLE #tempTable
 
--Create temp table
CREATE TABLE #tempTable (ID INT, UserName NVARCHAR(50));
 
-- Insert Multiple Values into SQL Server using UNION ALL
INSERT INTO #tempTable (ID, UserName) 
Select 1, `User1`
UNION ALL
Select 2, `User2`
UNION ALL
Select 2, `User2`
UNION ALL
Select 3, `User3`
 
--Select inserted values from temp table 
Select * From #tempTable