110,561
社区成员
发帖
与我相关
我的任务
分享
消息 207,级别 16,状态 1,第 12 行
列名 'ssze' 无效。
declare @indextable table(id int identity(1,1),nid int)
insert into @indextable(nid) select pro_ID from ( select g.*,
cpr_SignDate,
Convert(decimal(18,2),(Select isnull(SUM(payCount),0.00) From cm_CoperationCharge where cpr_ID=cm_Coperation.cpr_ID))as ssze
from cm_Project g inner join cm_Coperation on g.Pro_number =cm_Coperation.cpr_No)
temp where 1=1 AND ( Unit in ('全部部门','预算室','建筑创作室(Studio)','效果工作室','天泰图文','建筑一院','建筑二院','建筑三院','建筑四院','建筑五院','建筑六院','机电一院','机电二院','市政院','规划园林院','结构咨询室','勘察室','监理公司')) AND (ssze LIKE '%1000%') AND year(cpr_SignDate)=2016 Order by pro_Id desc
select pro_ID,Pro_number,Pro_numberChild,cpr_SignDate
,pro_buildUnit,pro_name,cpr_name,Unit,BuildArea,ProjectScale,cpr_Type,cm_Coperation.cpr_Acount,(select isnull(sum(payCount),0) from cm_CoperationCharge where cpr_ID=cm_Coperation.cpr_ID) ys,(cm_Coperation.Cpr_Acount-(select isnull(sum(payCount),0) from cm_CoperationCharge where cpr_ID=cm_Coperation.cpr_ID)) ws
,stuff((select','+cm_CoperationCharge.Times+convert(char(10),cm_CoperationCharge.paytime,120)+'收费为:'+convert(char(10),cm_CoperationCharge.payCount,20)from cm_CoperationCharge where cm_CoperationCharge.cpr_ID=cm_Coperation.cpr_Id for xml path('')),1,1,'') cs from cm_Coperation inner join cm_Project on cm_Project.Pro_number =cm_Coperation.cpr_No
inner join @indextable t on
cm_Project.pro_ID=t.nid
where t.id between 1 and 25 AND ( Unit in ('全部部门','预算室','建筑创作室(Studio)','效果工作室','天泰图文','建筑一院','建筑二院','建筑三院','建筑四院','建筑五院','建筑六院','机电一院','机电二院','市政院','规划园林院','结构咨询室','勘察室','监理公司')) AND (ssze LIKE '%1000%') AND year(cpr_SignDate)=2016 Order by pro_Id desc
select @Total=count(pro_ID) from (select g.*,cpr_SignDate,
Convert(decimal(18,2),(Select isnull(SUM(payCount),0.00) From cm_CoperationCharge where cpr_ID=cm_Coperation.cpr_ID)) as ssze
from cm_Project g inner join cm_Coperation on g.Pro_number =cm_Coperation.cpr_No)
temp where 1=1 AND ( Unit in ('全部部门','预算室','建筑创作室(Studio)','效果工作室','天泰图文','建筑一院','建筑二院','建筑三院','建筑四院','建筑五院','建筑六院','机电一院','机电二院','市政院','规划园林院','结构咨询室','勘察室','监理公司')) AND (ssze LIKE '%1000%') AND year(cpr_SignDate)=2016
(1 行受影响)
(1 行受影响)
ssze这一列好像不能在后面作为条件