22,206
社区成员
发帖
与我相关
我的任务
分享
SELECT @S='select '''' as bookingnumber,'''' as jobvslnumber,'''' as shipperfuname,
'''' as coneefuname,'''' as agentfuname,
vessel+''(Total)'' as vessel,'''' as voyage,'''' as por,'''' as polname,
'''' as etd,'''' as stshname,
'''' as comshname,sum(facttwentysize) as facttwentysize
,sum(factfourtysize) as factfourtysize,sum(facthq) as facthq,
sum(factfortyfivesize) as factfortyfivesize,'''' as bkgaddshname
,'''' as salesmanname,'''' as so,'''' as podname,'''' as services,'''' as FD,
sum(BerthCanceltwentysize)*0.5+sum(BerthCancelfourtysize)+sum(BerthCancelhq)+sum(BerthCancelfortyfivesize) as BerthCancelF,
sum(twentysize)*0.5+sum(fourtysize)+sum(hq)+sum(fortyfivesize) as ApplyF
from v_bk_BListProc ' + ltrim(@Sd)
+ ' and dbo.DateConvertWeek(si) between '+ ltrim(@Week1) + ' and '+ ltrim(@Week2)
+ ' group by vessel'
这样呢?
DECLARE @S VARCHAR(8000)
SELECT @S='select salesmanname,isnull(so,''Wating for SO release'') as so,podname,services,FD,
BerthCanceltwentysize*0.5+BerthCancelfourtysize+BerthCancelhq+BerthCancelfortyfivesize as BerthCancelF,
twentysize*0.5+fourtysize+hq+fortyfivesize as ApplyF
from v_bk_BListProc ' + @Sd
+ ' and dbo.DateConvertWeek(si) between '+ CAST(@Week1 AS NVARCHAR(5)) + ' and '+ CAST(@Week2 AS NVARCHAR(5))
DECLARE @S VARCHAR(8000)
SELECT @S='select salesmanname,isnull(so,''Wating for SO release'') as so,podname,services,FD,
BerthCanceltwentysize*0.5+BerthCancelfourtysize+BerthCancelhq+BerthCancelfortyfivesize as BerthCancelF,
twentysize*0.5+fourtysize+hq+fortyfivesize as ApplyF
from v_bk_BListProc ' + ltrim(@Sd)
+ ' and dbo.DateConvertWeek(si) between '+ ltrim(@Week1) + ' and '+ ltrim(@Week2)
EXEC(@S)