您本月等級:一般會員
您只要:
再購買 1 次
下個月即可升為:=convert(varchar,getdate(),112) and m.custno='v30417' union select distinct m.ordno from chain c(nolock),m_keroro m(nolock) where c.packno=m.ordno and m.shipterm='12' and m.state in ('f04','s55') and c.arrive2day>'0' and dateadd(day,3,(convert(char(8),c.arrive2day)))..
select count(*) as total from ( select distinct m.ordno from chain c(nolock),m_keroro m(nolock) where c.packno=m.ordno and m.shipterm=^02^ and m.state in (^f04^,^s55^) and c.arrive2day>^0^ and dateadd(day,7,(convert(char(8),c.arrive2day)))>=convert(varchar,getdate(),112) and m.custno=^rebeccalong^ ..