Skip to content

Instantly share code, notes, and snippets.

@jibinpb

jibinpb/select_node_and_edge.sql

Created August 1, 2018 05:28
Show Gist options
  • Save jibinpb/36f700c1d4edbefa87c4d296b3bd1292 to your computer and use it in GitHub Desktop.
Save jibinpb/36f700c1d4edbefa87c4d296b3bd1292 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server GDB - Select from Edge and Node
Raw
select_node_and_edge.sql
SELECT
entity1.Name AS [Parent],
entity2.Name AS [Subsidiary],
s.HoldingPercentage,
s.EffectiveDate
FROM [Entity] entity1, [Subsidiaries] s, [Entity] entity2
WHERE MATCH(entity1-(s)->entity2);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment