Hi all,
CREATE TABLE #TEMP
(
id int not null,
Accountname varchar(50)
)
CREATE TABLE #UsersEqualtoWebUser
(
id int identity(1,1),
AccountName varchar(100)
)
INSERT INTO #TEMP(id , Accountname)
SELECT 1 , 'ctest0067' union all
SELECT 2 , 'ctest01' union all
SELECT 3 , 'cTest0190' union all
SELECT 4 , 'bstacy11' union all
SELECT 5 , 'bstacy12' union all
SELECT 6 , 'ftest011' union all
SELECT 7 , 'ftest2' union all
SELECT 8 , 'ftest3' union all
SELECT 9 , 'ftest4' union all
SELECT 10 , 'ftestcad8'
Want to insert AccountName into table #UsersEqualtoWebUser
around x number of time and AccountName should be in same order as is in the #TEMP
let say x = 500 for now
thanks in advance