SQL创建存储过程[横向显示列的数据]

-- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block of comments will not be included in -- the definition of the procedure. -- ================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= Alter PROCEDURE sp_get_in_data -- Add the parameters for the stored procedure here @billno varchar(20) = '' AS declare @sql varchar(8000),@i int BEGIN set @i=0; set @sql=' select pro_id as 货号,pro_name as 名称 ' ; select @i=@i+1,-- 有多少行，@i就增加几次. @sql=@sql+' ,sum(case style when '''+ style_var +'''then qty else 0 end)as '''+style_var+''' ' from ( select distinct name as style_var from t001 -- 模本表 ) tem; set @sql=@sql+' from t002 where billno = '''+@billno+''' group by pro_id,pro_name' -- 执行动态SQL语句. exec(@sql) END GO