AnsweredAssumed Answered

Create View SQL

Question asked by md96 on Oct 22, 2015
Latest reply on Oct 23, 2015 by md96

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

SELECT Leaf.RouteId

FROM Leaf

GROUP BY Leaf.RouteId

PIVOT Leaf.Cycle;

 

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?

Outcomes