Insert Into @t select 1,4,7 union all select 2,5,8 union all select 3,6,9

select d = a from @t union 
select b from @t union 
select c from @t

string tblName = "someTblName";
string str = string.Format("Select * From {0} ", tblName);

Declare @str varchar(50) = '"vini katyal" <vinikatyal@yahoo.com>'

Select 
		Name  = Left(@str, PATINDEX('%<%',@str)-1)
		,Domain = Right(@str,Len(@str)-PATINDEX('%<%',@str)+1)
		,Email = @str

Select 
		Name  = Left(@str, CHARINDEX('<',@str)-1)
		,Domain = Right(@str,Len(@str)-CHARINDEX('<',@str)+1)

Declare @table1 table(T1Col1 int,T1Col2 int,T1Col3 varchar(50))
Insert Into @table1 Select 175, 056,'venkatesh'

Declare @table2 table(T2Col1 int,T2Col2 varchar(50),T2Col3 varchar(50))
Insert Into @table2 Select 056,'venkatesh','NV'

Select 
		t1.*
		,t2.*
From @table1 t1
Join @table2 t2
On t1.T1Col2 = t2.T2Col1

Select Cast(ID as Varchar(10)) + REPLACE(CONVERT (VARCHAR(10), TransactionDate, 101), '/', '') As TransactionID

Run a job scheduler or a background

Field   DataType
------  --------
RowID (AutoIncrement)
ID     Number
Open   Number
Close  Number

Insert into Table1(ID,Open)
Select  Table1.[ID], Table1.[Close]
FROM Table1
where  Table1.[RowID] =  ( Select Count(*) from Table1);

Name Result
John 90.00
John 95.00
John 98.00
Abraham 86.56
Abraham 23.67

Declare

' set rst=conn.execute

("

select 

Watchedprofileid 
, p.pdjobtitle
,M.WatchinguserID 

from tblWatches M 

INNER join tblother P 

ON M.WatchinguserID = P.UserId  

where M.WatchinguserID > 5

And M.WatchinguserID = " & rs("userID")

)