USE NorthWind

 SELECT x.OrderID,
        x.Freight,
       (SELECT SUM(y.Freight)
          FROM dbo.Orders y
         WHERE y.OrderID <= x.OrderID) AS RunningTotal,
       (SELECT COUNT(y.Freight)
          FROM dbo.Orders y
         WHERE y.OrderID <= x.OrderID) AS RunningCount
   FROM dbo.Orders X 
  ORDER BY x.OrderID

--===== Create and preset a loop counter
DECLARE @Counter INT
    SET @Counter = 1

--===== Count from 1 to 10
  WHILE @Counter <= 10
  BEGIN
        SELECT @Counter
           SET @Counter = @Counter + 1
    END 

--===== Count from 1 to 10
 SELECT N
   FROM dbo.Tally
  WHERE N <= 10