Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
DECLARE @SalesTbl TABLE (DayCount smallint, Sales money, RunningTotal money) DECLARE @DayCount smallint, @Sales money, @RunningTotal money SET @RunningTotal = 0 DECLARE rt_cursor CURSOR FOR SELECT DayCount, Sales FROM tSales ORDER BY DayCount OPEN rt_cursor FETCH NEXT FROM rt_cursor INTO @DayCount,@Sales WHILE @@FETCH_STATUS = 0 BEGIN SET @RunningTotal = @RunningTotal + @Sales INSERT @SalesTbl VALUES (@DayCo