SELECT *

  FROM [goods]

 DECLARE test_cursor CURSOR scroll FOR

    SELECT goods_no,

           [unitprice]

    FROM   [goods]

  OPEN test_cursor

  DECLARE @goodsno INT

  DECLARE @num numeric(10, 2)

  FETCH next FROM test_cursor INTO @goodsno, @num

  WHILE @@FETCH_STATUS = 0

   begin

      PRINT @goodsno

      PRINT @num

   IF @num % 2 = 0

    update [goods] set sex='男' where goods_no=@goodsno

  ELSE

    update [goods] set sex='女' where goods_no=@goodsno

      FETCH next FROM test_cursor INTO @goodsno, @num

   end

  CLOSE test_cursor

  DEALLOCATE test_cursor
  

DECLARE @BeginDate DATE;

SELECT @BeginDate = '2013-1-1';

WHILE @BeginDate <= '2014-2-8'

  BEGIN

  DECLARE test_cursor CURSOR scroll FOR

  select 渠道ID from Dim_渠道 where 经营方式='自营'

  OPEN test_cursor

  DECLARE @customerNo varchar(60)

  FETCH next FROM test_cursor INTO @customerNo

  WHILE @@FETCH_STATUS = 0

   begin

      PRINT @customerNo

      insert into Fact_终端销售动作

      values(@customerNo,@customerNo,CONVERT(VARCHAR(8), @BeginDate, 112),

      cast(ceiling(rand() * 100) as int),

      cast(ceiling(rand() * 20) as int))

      FETCH next FROM test_cursor INTO @customerNo

   end

     SET @BeginDate = Dateadd(DAY, 1, @BeginDate);

  CLOSE test_cursor

  DEALLOCATE test_cursor

  end