UC知道请教个ASP菜鸟问题
来源：百度知道 编辑：UC知道 时间：2024/06/21 18:30:46
目的很简单 就是想将手工输入的方式改成将变量自动套用而已。我目前没有积分，以后有了一定双手奉上，希望能得到热心人指点指点，谢谢！
先看看原先的代码：
sql= "select Dim_SKU.SKU,Dim_SKU.SKUDesc,"
sql=sql & "sum(case when LocationCode='S001' then totalqty else 0 end ) as s001qty,"
sql=sql & "sum(case when LocationCode='S003' then totalqty else 0 end ) as s003qty,"
sql=sql & "sum(case when LocationCode='S004' then totalqty else 0 end ) as s004qty,"
。
。有N列s001、s003就要写N多行
。
sql=sql & "sum(case when LocationCode='ZZO' then totalqty else 0 end ) as ZZOqty "
sql=sql & " From HKSOH "
sql=sql & " inner join Dim_Location on HKSOH.Location=Dim_Location.LocationCode "
sql=sql & " inner join Dim_SKU on HKSOH.SKU=Dim_SKU.SKU "
sql=sql & " where HKSOH.SKU like '"&sku&"%' "
sql=sql & " group by Dim_SKU.SKU , Dim_SKU.SKUDesc "
set r
先看看原先的代码：
sql= "select Dim_SKU.SKU,Dim_SKU.SKUDesc,"
sql=sql & "sum(case when LocationCode='S001' then totalqty else 0 end ) as s001qty,"
sql=sql & "sum(case when LocationCode='S003' then totalqty else 0 end ) as s003qty,"
sql=sql & "sum(case when LocationCode='S004' then totalqty else 0 end ) as s004qty,"
。
。有N列s001、s003就要写N多行
。
sql=sql & "sum(case when LocationCode='ZZO' then totalqty else 0 end ) as ZZOqty "
sql=sql & " From HKSOH "
sql=sql & " inner join Dim_Location on HKSOH.Location=Dim_Location.LocationCode "
sql=sql & " inner join Dim_SKU on HKSOH.SKU=Dim_SKU.SKU "
sql=sql & " where HKSOH.SKU like '"&sku&"%' "
sql=sql & " group by Dim_SKU.SKU , Dim_SKU.SKUDesc "
set r
set loc=conn.execute("SELECT DISTINCT LocationCode FROM Dim_Location where LocationCode not like '*%'")
sql= "select Dim_SKU.SKU,Dim_SKU.SKUDesc,"
do while not loc.eof
strlocationcode=loc("LocationCode")
sql=sql & "sum(case when LocationCode='"& strlocationcode &"' then totalqty else null end ) as "& strlocationcode &"qty,"
loc.movenext
loop
为什么不直接把两个循环结合了呢?你列的不是问题的全部.直接把数据库列出来,说明想实现什么!
没理解你要做什么，不过复杂的SQL语句用存储过程是最好的了
其实是个很简单的问题来的，我有一个SQL语句，会将搜到的内容循环输出。但我现在要将原来的SQL语句中的一系列条件S001等自动由一个表导入，所以我又要再写一个循环来将S001调入，但这样写的话，两个循环之间就互相影响了，所以我想问的是如何写这样的两个循环。我是提问题的本人。