ALTER PROCEDURE [dbo].[usp_yw200]
(@whereflt NVARCHAR(MAX),
@groupcol NVARCHAR(100))
AS
BEGIN
DECLARE @sql NVARCHAR(MAX);
SET @sql = 'SELECT 客户 ,' +@groupcol+ ', sum(数量) as 数量 from 订单明细 a inner join 订单 b on a.订单编号 = b.订单编号'
if @whereflt is not null
begin
SET @sql = @sql+ ' where '+ @whereflt
end
SET @sql = @sql + ' group by 客户,' +@groupcol;
--select @sql
EXEC sp_executesql @sql;
END;
用select @sql看拼凑的真正sql是什么就知道问题在哪