Hello guys,
I need to tranform columns into rows or rows into columns.
I'm using only SQL Cache.
The code:
SELECT
codRepresentante
,vendasAbril
,vendasAgosto
FROM
Ped.MetasRepresen
WHERE ano = 2024
The columns:
InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.