DB_51aspx/2014年/存储过程or函数/存储过程-查询预约中客户提交的信息.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

 
---查询预约中，客户提交的信息
ALTER PROCEDURE p_yuyue
@formid int

as
BEGIN
 declare @fid int
declare @sql varchar(500)
set @fid=@formid
set @sql='select openid,createDate'
select @sql=@sql+',max(case cName when '''+cName+''' then userResult else '''' end) ['+cName+']'

from (select distinct cName from wx_yy_result where   formid=@fid) a --同from tb group by课程，默认按课程名排序
 
set @sql=@sql+' from  (select * from  wx_yy_result where formid='+ convert(varchar,@fid) +' )  wx_yy_result group by openid,createDate order by createDate desc'

 exec(@sql)

END
GO

---测试 
exec p_yuyue 3