A.B.Cade
2013-03-19 13:58:55
You can't put a non constant string in the IN clause of the pivot clause.
You can use Pivot XML for that.
From documentation:
subquery A subquery is used only in conjunction with the XML keyword. When you specify a subquery, all values found by the subquery are used for pivoting
It should look like this:
select xmlserialize(content t.B_XML) from t_aa
pivot xml(
sum(A) for B in(any)
) t;
You can also have a subquery instead of the ANY keyword:
select xmlserialize(content t.B_XML) from t_aa
pivot xml(
sum(A) for B in (select cl from t_bb)
) t;
热门帖子
热门github
6
hi your method is working actually but output i am getting in xml format. can i get output as a table with rows and columns ?
AFAIK, not dynamically... But how do you intend to use a result which you don't know its structure ?