遍历map,利用在带有游标的过程中使用 WHILE的方法取出各个门店零售的销售数据(遍历多表取出数字)

@@FETCH_STATUS

---------------------------------------------------------------- -- 设计系统中取数的程序如下： ---------------------------------------------------------------- ----通过WHILE 语句遍历 Declare @sDate char(10) Declare @sSQL varchar(8000) select @sDate= Convert(Varchar(10),getdate(),120) --set @sDate='2010-11-01' begin set @ssql = 'DELETE FROM XJY_JXC_SUP_DETAIL WHERE (RUN_DATE='''+@sDate+''') AND md_x<>0 AND x<>0' Exec(@sSQl) end DECLARE tnames_cursor CURSOR FOR SELECT 'ShopProdSale'+ShopCode FROM ShopItem where shoptype='01' OPEN tnames_cursor DECLARE @tablename sysname --SET @tablename = 'authors' FETCH NEXT FROM tnames_cursor INTO @tablename WHILE (@@FETCH_STATUS <> -1) BEGIN IF (@@FETCH_STATUS <> -2) BEGIN SELECT @tablename = RTRIM(@tablename) set @sSQL=' insert into XJY_JXC_SUP_DETAIL (run_date,suppl_No,x,x_qty,md_x,md_x_qty,XJY_SUP_DEMO) SELECT t1.wdate, t2.supcode, sum(SaleAmt) as x, sum(CountN) as x_qty, sum(SaleAmt) as md_x, sum(CountN) as md_x_qty, '+''''+SubString(@tablename,13,3)+'号店销售'+''''+' from '+@tablename+' t1, product1 t2 where t1.prodcode = t2.prodcode and (WDate='''+@sDate+''') group by t1.wdate, t2.supcode' Exec(@sSQl) --print(@ssql) END FETCH NEXT FROM tnames_cursor INTO @tablename END CLOSE tnames_cursor DEALLOCATE tnames_cursor

Tags:  前序遍历 龙龙内存遍历工具 二叉树遍历 php遍历数组 遍历map

延伸阅读

• 2010-12-9-- php遍历目录,php遍历目录viewDir函数
• 2010-12-27-- php遍历目录,浅析PHP程序中的目录遍历漏洞
• 2010-12-9-- php遍历数组,Javascript技巧之不要用for in语句对数组进行遍历
• 2010-12-9-- php数组,PHP中的array数组类型分析说明
• 2011-3-11-- php遍历数组,JavaScript奇技淫巧之遍历数组
• 2010-12-9-- php数组,PHP 数组基础知识小结
• 2010-12-9-- 图的遍历,php is_file（）和is_dir（）用于遍历目录时用法注意事项
• 2010-12-9-- php数组,比较全面的PHP数组的使用方法小结
• 2011-3-12-- 二叉树遍历递归,二叉树的非递归遍历
• 2011-1-4-- 二叉树,二叉树学习笔记