, - YUOU可以创建表和存储过程,并执行1行
1
{C}EXEC sp_Ins_Up_TestIF '907',1,'28 / 06/2011','8 / 2/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653 -4214-881b-3c924f2a086c'exec sp_Ins_Up_TestIF '907',2,'28/06/2011','8/1/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653-4214-881b-3c924f2a086c'
update Pl_Material_Stock_Closing_Daily set QtyS='1'
exec sp_Ins_Up_TestIF '907',2,'28/06/2011','8/1/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653-4214-881b-3c924f2a086c'
exec sp_Ins_Up_TestIF '907',2,'28/06/2011','8/2/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653-4214-881b-3c924f2a086c'
exec sp_Ins_Up_TestIF '907',2,'28/06/2011','8/3/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653-4214-881b-3c924f2a086c'
exec sp_Ins_Up_TestIF '907',2,'28/06/2011','8/4/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653-4214-881b-3c924f2a086c'
exec sp_Ins_Up_TestIF '907',1,'28/06/2011','8/4/2011 12:00:00 AM','4','b600e996-bfd7-4632-88d6-89e6275ba404','a66a75d5-6653-4214-881b-3c924f2a086c'
{体C3}{的C4}{C5的}--Result of Stock Should : 8/2/2011:6,8/3/2011:8,8/4/2011:8
--Means A LOOP should Update Rows 2,3,4 Add 1 in all three Rows