hehe
with wares as
(
SELECT distinct a.Wid as wid,
a.Wname as wareName,
a.warejia as warePrice,
row_number() OVER(ORDER BY a.wid asc) AS rownumss
FROM ware a WITH (NOLOCK),GYS_Ware (nolock) gw
,SplitStr(#sku#) as t1
,SplitStr(#caigouRange#) as t2
,Splitint(#caiGouYuan#) as p
,SplitStr(#thirdCategoryRange#) as t4
,SplitStr(#wpidList#) as t5
len(a.wid)<9
a.wid = t1.value
(
a.caigou = p.value
or
a.wid in (select wid from waremaster with (nolock) where usertype=2 and userid= (select op_code from admin(nolock) where id= p.value))
)
a.WPid = t4.value
a.WPid = #smallType#
a.WPid = t5.value
a.Wyn = 1 and a.wfacturer=gw.brand and gw.gysid = #suppId#
a.wstate = #wstate#
a.Wfacturer = #pinPai#
a.shangjia=#sjName#
a.wname like '%' + #goodsName# + '%'
gw.gysid = #suppId#
group by a.Wid, a.Wname,a.warejia
)
select wid,wareName,warePrice,rownums
from wares with (nolock)
http://www.tmall.com/go/act/sale/yuemogou.php?spm=3.1000473.295813.31.GkzG2T&ad_id=&am_id=1301047866016600e9b4&cm_id=&pm_id=
最新文章
- 注册表信息(安装包ProductCode,设置启动运行)
- file_get_contents高級用法
- java 1G大文件复制
- 在ASP.NET MVC中的四大筛选器(Filter)及验证实现
- debuggap,移动端调试新方式
- [计算机基础]HTTP协议学习笔记
- Java多种方式读文件,追加文件内容,等对文件的各种操作
- springboot整合redis(注解形式)
- ionic3 应用内打开第三方地图导航 百度 高德
- Python3.6.2安装pip install paramike模块报错
- NodeManager介绍
- git 使用ssh密钥
- MySql实现sequence功能的代码
- php的基本内容
- Docker命令之 exec
- C++ vs Python向量运算速度评测
- sts安装出现could not find jar:file解决办法
- MFC 的SetWindowPos 用法
- 《Python3网络爬虫开发实战》PDF+源代码+《精通Python爬虫框架Scrapy》中英文PDF源代码
- 【bzoj3203】[Sdoi2013]保护出题人 凸包+二分