27,582
社区成员




select * form
(
select
cast(substring('201001',1,4)+'12' as VARCHAR(6)) as CTRMONTHYEAR,
cast(upper(C.COMMODITYID)+substring('201001',1,4)+'1201' as VARCHAR(50)) as ORDERCOL,
*
from
CTR C
where
C.CTRBOOKID=104
and
C.SLRID =1081
and
(C.SHIPMONTHNUMBER >=200910 and C.SHIPMONTHNUMBER <=201001 )
)as t
group by
--cast(case when (C.SLRID =1081 ) then 'Sales' else 'Purchases' end as VARCHAR(10)),
SHIPMONTHNUMBER,
COMMODITYID,
CTRMONTHYEAR,
ORDERCOL
[Quote=引用 5 楼 yeshucheng 的回复:]
我是说不使用存储过程呢?如何处理
[/Quote]
select * form
(
select
cast(substring('201001',1,4)+'12' as VARCHAR(6)) as CTRMONTHYEAR,
cast(upper(C.COMMODITYID)+substring('201001',1,4)+'1201' as VARCHAR(50)) as ORDERCOL,
from
CTR C
where
C.CTRBOOKID=104
and
C.SLRID =1081
and
(C.SHIPMONTHNUMBER >=200910 and C.SHIPMONTHNUMBER <=201001 )
)as t