交叉表查询处理问题

如果字段里面的值都是固定```也就是说至少A表固定的话```

这题值50

如果说A表不固定的话````里面还有什么第四第五 ,不固定的话````呵呵```

至少200以上````

如果都觉得贵了```那就参考我的例子自己写````

use master
create table tb(id char(2) ,AA CHAr(10),BB char(10),CC CHAr(10))
INSERT INTO tb
SELECt '1','ASGAHDF','ccc','HSNS' union all
select '2','sdfsa','dd','SBSH' UNIOn ALL
select '3','sSGDH','DCD','JRTJK' UNIOn ALL
select '4','fJKDH','OP9V','T48JI' UNIOn ALL
select '5','sJDNR','NTY','T161I' UNIOn ALL
select '6','DNDH','HSDR','XDYURI' UNIOn ALL
select '7','DNJKDH','DHN','TSDJ' UNIOn ALL
select '8','sJngKH','HBNRV','TYMRT9I' UNIOn ALL
select '9','Krm5DH','SHE','D9NKUI'
SELECT * FROM tb

go
declare @sql1 varchar(8000),@sql2 varchar(8000),@sql3 varchar(8000),@sql4 varchar(8000)

set @sql1='select ''AA'' id '
set @sql2='select ''BB'' id'
set @sql3='select ''CC'' id'
set @sql4=''
select @sql1 = @sql1 +', (case id when id then '''+AA+''' end) ['+ id+' ]' from (select distinct * from tb) as a
set @sql1=@sql1+' from tb '
select @sql2 = @sql2 +', (case id when id then '''+BB+''' end) ['+ id+' ]' from (select distinct * from tb) as b
set @sql2=@sql2+' from tb '
select @sql3 = @sql3 +', (case id when id then '''+CC+''' end) ['+ id+' ]' from (select distinct * from tb) as a
set @sql3=@sql3+' from tb '
set @sql1= 'select distinct * from ('+@sql1+') as a '
set @sql2= 'select distinct * from ('+@sql2+') as b'
set @sql3= 'select distinct * from ('+@sql3+') as c'
set @sql4 = @sql1+' union all '+@sql2+' union all '+@sql3
exec(@sql4)

go
drop table tb

（所影响的行数为 9 行）

id AA BB CC
---- ---------- ---------- ----------
1 ASGAHDF ccc HSNS
2 sdfsa dd SBSH
3 sSGDH DCD JRTJK
4 fJKDH OP9V T48JI
5 sJDNR NTY T161I
6 DNDH HSDR XDYURI
7 DNJKDH DHN TSDJ
8 sJngKH HBNRV TYMRT9I
9 Krm5DH SHE D9NKUI

（所影响的行数为 9 行）

id 1 2 3 4 5 6 7 8 9
---- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
AA ASGAHDF sdfsa sSGDH fJKDH sJDNR DNDH DNJKDH sJngKH Krm5DH
BB ccc dd DCD OP9V NTY HSDR DHN HBNRV SHE
CC HSNS SBSH JRTJK T48JI T161I XDYURI TSDJ TYMRT9I D9NKUI