As mentioned, a WHILE loop is possible
SET @ICount = 1
WHILE (@ICount <= @10)
SET @ICount = (@ICount + 1)
However, for what you want to do it's completely the wrong thing. 'The Cyclone' answer is correct.
You definitely need to think more along these lines with SQL, get away from the idea of loops - you can usually achieve what you need with the correct usage of SQL.
There are only a few rare cases where I choose a loop in TSQL.