- 积分
- 45
- UID
- 22709
- 阅读权限
- 10
- 注册时间
- 2016-8-11
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 4
|
4#
楼主 |
发表于 2016-8-15 09:08:58
|
只看该作者
SELECT a.item_id,a.brand_id,a.item_year as year_id,a.sea_id,b.sea_name,
a.ic_id,c.ic_name,case when c.ic_prop=0 then 'Y' else 'N' end as is_acc,a.org_price as sale_price,a.item_desc,
CONVERT(varchar(10), DATEADD(m, 0,RTRIM(CASE WHEN (b.e_mon < b.s_mon AND b.sea_id = 1)
THEN a.item_year - 1 ELSE a.item_year END) + '-' + RTRIM(b.s_mon) + '-01'), 120) AS s_date,
CONVERT(varchar(10), DATEADD(d, - 1, DATEADD(m, 1, RTRIM(CASE WHEN (b.e_mon < b.s_mon AND b.sea_id = 4)
THEN a.item_year + 1 ELSE a.item_year END) + '-' + RTRIM(b.e_mon) + '-01')), 120) AS e_date
FROM SYDB0028.dbo.item_master a,SYDB0028.dbo.sea_info b,SYDB0028.dbo.item_category c
where a.data_state=2 and b.sea_id=a.sea_id and c.ic_id=a.ic_id
能帮忙讲解一下上面的语句吗? |
|