Declare @TempTableVariable TABLE( UserID int, UserName varchar(50), UserAddress varchar(150)) insert into @TempTableVariable values ( 1, 'Abhijit','India');
IF OBJECT_ID('tempdb..#t1') IS NOT NULL DROP TABLE #t1 SELECT * INTO #t1 from ( SELECT Column1 FROM table1 union SELECT column2 FROM table1) a SELECT * FROM #t1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)