lamdacomplex

Sorry, meant to also include a link to the documentation for Edge constraints and SHORTEST_PATH which include examples of valid syntax. https://docs.microsoft.com/en-us/sql/relational-databases/tables/graph-edge-constraints?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-shortest-path?view=sql-server-ver15#examples

Ops Clicked the close by accident. Meant to just reply. I've had mixed results in SSMS. I have a query right now that uses similar queries with the same syntax...