A little reminder of how to use while loop with SQL. Basic structure DECLARE @Count INT SET @Count = 0 WHILE(@Count < 11) BEGIN PRINT 'I have walked ' + CONVERT(VARCHAR, @Count) + ' meters today' SET