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