Query to Pivot table in Sybase

hazel14

I have problem when i copy this sql to sybase stored procedure, Sybase does not recognize keyword 'QUOTENAME' AND 'REPLACE'.

In sql server it works well.

Do help. TQ.

TQ again for the sql code.

hazel14

0 4

Sybase also did not recognize ARRAY_AGG.. what keyword to use? OR Is there anyway that i can make pivot without pivot function? help please.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html