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.

dharmend...

0 2

Use ARRAY_AGG and REPLACE functions in Sybase.

For more details refer below links.

https://www.postgresqltutorial.com/postgresql-aggregate-functions/postgresql-array_agg/

https://www.postgresqltutorial.com/postgresql-string-functions/postgresql-replace/

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