纵向变横向,是可变的,查找资料说要用如下的存储过程:
declare @s varchar(8000)
set @s=''
select @s=@s+',['+cast(ygxz as varchar)+']=sum(case ygxz when '''+cast(ygxz as varchar)+''' then 1 end)'
From xxxb
group by bm
exec('select bm'+@s+' from xxxb group by bm')
可我不知道如何执行上面的存储过程,能否将代码直接复制到VB过程中运行(好象不行,是吧?),必须要在SQL中建立存储过程吗?又如何调用呢?具体怎样用,请详细说明,感激涕零!
(本人是新手,对存储过程是一窍不通,越详细越好。)