貌似是group by 的上一行结尾少了一个“+”:CREATE PROCEDURE zz_tempCreateView
AS
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zztempView]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop view [dbo].[zztempView]
declare @CreateView varchar(2000)
set @CreateView='Create View zztempView '+
'AS '+
'SELECT '+
'dbo.KCWLYE.KCWLYE_KJND AS 年, dbo.KCWLYE.KCWLYE_KJQJ AS 月,'+
'dbo.KCWLYE.KCWLYE_WLBH AS 物料编号,dbo.LSWLLB.LSWLLB_LBMC AS 类别名称'+
'SUM(dbo.XSSSFQZY.XSSSFQZY_BBDFJE) AS 贷方金额,'+
'dbo.LSWLZD.LSWLZD_WLMC AS 物料名称,'+
'dbo.LSWLZD.LSWLZD_GGXH AS 规格型号,'+
'dbo.LSWLZD.LSWLZD_JLDW AS 计量单位,'+
'dbo.LSWLZD.LSWLZD_XSJL AS 辅助计量单位1,'+
'dbo.LSWLZD.LSWLZD_FZDW AS 辅助计量单位2, SUM(dbo.KCWLYE.KCWLYE_JFSL) '+
'AS 本期借方数量, SUM(dbo.KCWLYE.KCWLYE_DFSL) AS 本期贷方数量,'+
'SUM(dbo.KCWLYE.KCWLYE_SLYE) AS 期末数量,'+
'SUM(dbo.KCWLYE.KCWLYE_FJFSL1) AS 本期借方数量1,'+
'SUM(dbo.KCWLYE.KCWLYE_FDFSL1) AS 本期贷方数量1,'+
'SUM(dbo.KCWLYE.KCWLYE_FSLYE1) AS 期末数量1,'+
'SUM(dbo.KCWLYE.KCWLYE_FJFSL2) AS 本期借方数量2,'+
'SUM(dbo.KCWLYE.KCWLYE_FDFSL2) AS 本期贷方数量2,'+
'SUM(dbo.KCWLYE.KCWLYE_FSLYE2) AS 期末数量2 '+
'FROM dbo.XSSSFQZY INNER JOIN '+
'dbo.KCWLYE ON '+
'dbo.XSSSFQZY.XSSSFQZY_KJQJ = dbo.KCWLYE.KCWLYE_KJQJ AND '+
'dbo.XSSSFQZY.XSSSFQZY_KJND = dbo.KCWLYE.KCWLYE_KJND AND '+
'dbo.XSSSFQZY.XSSSFQZY_WLBH = dbo.KCWLYE.KCWLYE_WLBH INNER JOIN '+
'dbo.LSWLZD ON '+
'dbo.KCWLYE.KCWLYE_WLBH = dbo.LSWLZD.LSWLZD_WLBH INNER JOIN '+
'dbo.LSWLLB ON '+
'dbo.LSWLZD.LSWLZD_LBBH = dbo.LSWLLB.LSWLLB_LBBH '+
'WHERE '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_JFSL <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_JFSL1 <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_JFSL2 <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_DFSL <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_DFSL1 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_DFSL2 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
' (dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_SLYE <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02 %'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_FSLYE1 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_FSLYE2 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') '+
'group by dbo.LSWLLB.LSWLLB_LBMC,dbo.KCWLYE.KCWLYE_KJND,dbo.KCWLYE.KCWLYE_KJQJ,dbo.KCWLYE.KCWLYE_WLBH,dbo.LSWLZD.LSWLZD_WLMC,dbo.LSWLZD.LSWLZD_GGXH,dbo.LSWLZD.LSWLZD_JLDW,dbo.LSWLZD.LSWLZD_XSJL,dbo.LSWLZD.LSWLZD_FZDW '
Exec(@CreateView)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zztempView]') and OBJECTPROPERTY(id, N'IsView') = 1)
return 1
else
return 0
AS
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zztempView]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop view [dbo].[zztempView]
declare @CreateView varchar(2000)
set @CreateView='Create View zztempView '+
'AS '+
'SELECT '+
'dbo.KCWLYE.KCWLYE_KJND AS 年, dbo.KCWLYE.KCWLYE_KJQJ AS 月,'+
'dbo.KCWLYE.KCWLYE_WLBH AS 物料编号,dbo.LSWLLB.LSWLLB_LBMC AS 类别名称'+
'SUM(dbo.XSSSFQZY.XSSSFQZY_BBDFJE) AS 贷方金额,'+
'dbo.LSWLZD.LSWLZD_WLMC AS 物料名称,'+
'dbo.LSWLZD.LSWLZD_GGXH AS 规格型号,'+
'dbo.LSWLZD.LSWLZD_JLDW AS 计量单位,'+
'dbo.LSWLZD.LSWLZD_XSJL AS 辅助计量单位1,'+
'dbo.LSWLZD.LSWLZD_FZDW AS 辅助计量单位2, SUM(dbo.KCWLYE.KCWLYE_JFSL) '+
'AS 本期借方数量, SUM(dbo.KCWLYE.KCWLYE_DFSL) AS 本期贷方数量,'+
'SUM(dbo.KCWLYE.KCWLYE_SLYE) AS 期末数量,'+
'SUM(dbo.KCWLYE.KCWLYE_FJFSL1) AS 本期借方数量1,'+
'SUM(dbo.KCWLYE.KCWLYE_FDFSL1) AS 本期贷方数量1,'+
'SUM(dbo.KCWLYE.KCWLYE_FSLYE1) AS 期末数量1,'+
'SUM(dbo.KCWLYE.KCWLYE_FJFSL2) AS 本期借方数量2,'+
'SUM(dbo.KCWLYE.KCWLYE_FDFSL2) AS 本期贷方数量2,'+
'SUM(dbo.KCWLYE.KCWLYE_FSLYE2) AS 期末数量2 '+
'FROM dbo.XSSSFQZY INNER JOIN '+
'dbo.KCWLYE ON '+
'dbo.XSSSFQZY.XSSSFQZY_KJQJ = dbo.KCWLYE.KCWLYE_KJQJ AND '+
'dbo.XSSSFQZY.XSSSFQZY_KJND = dbo.KCWLYE.KCWLYE_KJND AND '+
'dbo.XSSSFQZY.XSSSFQZY_WLBH = dbo.KCWLYE.KCWLYE_WLBH INNER JOIN '+
'dbo.LSWLZD ON '+
'dbo.KCWLYE.KCWLYE_WLBH = dbo.LSWLZD.LSWLZD_WLBH INNER JOIN '+
'dbo.LSWLLB ON '+
'dbo.LSWLZD.LSWLZD_LBBH = dbo.LSWLLB.LSWLLB_LBBH '+
'WHERE '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_JFSL <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_JFSL1 <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_JFSL2 <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_DFSL <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_DFSL1 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_DFSL2 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
' (dbo.KCWLYE.KCWLYE_KJND = 2009) AND (dbo.XSSSFQZY.XSSSFQZY_SLYE <> 0) '+
'AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) AND '+
'(dbo.LSWLLB.LSWLLB_LBBH LIKE ''02 %'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_FSLYE1 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') OR '+
'(dbo.KCWLYE.KCWLYE_KJND = 2009) AND '+
'(dbo.XSSSFQZY.XSSSFQZY_FSLYE2 <> 0) AND (dbo.KCWLYE.KCWLYE_KJQJ = 01) '+
'AND (dbo.LSWLLB.LSWLLB_LBBH LIKE ''02%'') '+
'group by dbo.LSWLLB.LSWLLB_LBMC,dbo.KCWLYE.KCWLYE_KJND,dbo.KCWLYE.KCWLYE_KJQJ,dbo.KCWLYE.KCWLYE_WLBH,dbo.LSWLZD.LSWLZD_WLMC,dbo.LSWLZD.LSWLZD_GGXH,dbo.LSWLZD.LSWLZD_JLDW,dbo.LSWLZD.LSWLZD_XSJL,dbo.LSWLZD.LSWLZD_FZDW '
Exec(@CreateView)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zztempView]') and OBJECTPROPERTY(id, N'IsView') = 1)
return 1
else
return 0
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货