Hello;
I want to transpose tg_prod_predict01b2 -
create table aaa as
SELECT *
FROM (
SELECT position, fte_type, pay_period_end_date, fte_count,exprpp
FROM tg_prod_predict01b2
)
PIVOT (
SUM(fte_count) FOR exprpp IN ('exp') -- This is where the error is
);
Can you tell me why I am getting invalid number error please?