Dear All,
Kindly advise why is it that we cant use select statement inside the PIVOT phrase.
ie in the portion highlighted in bold below,
select * from(
)
PIVOT
(
Aggregate_Function<column_name_1> FOR <column_name_2> IN (select <column_name_temp> from <table_name>)
);
NB : Discussion example query created under
Thanks and Regards,
Vysakh Suresh