I am using New > View to try to create a database view in SQLExpress. I want to pivot the table like it works in this Access query:
TRANSFORM First(Leaf.last_edi_1) AS FirstOflast_edi_1
GROUP BY Leaf.RouteId
I have tried making something similar work in with SQL to create a database view with no luck. I can get the RouteId as rows, but can't figure out how to make the 10 cycles show up as columns with the last_edited_date filled in - it always errors on Pivot. Can I not use Pivot in Esri and/or SQLExpress? If not, is there a work around to transpose the table with Create View?