SQL Query for Parent Child Relationship

by 
with [CTE] as (
    select * from [TheTable] c where c.[ParentId] = 1
    union all
    select * from [CTE] p, [TheTable] c where c.[ParentId] = p.[NodeId]
)
select * from [CTE]

More Related Contents:

  1. SQL query for parent-child chain
  2. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. The multi-part identifier could not be bound
  5. Fastest way to update 120 Million records
  6. Can a Check constraint relate to another table?
  7. Is it possible to select sql server data using column ordinal position
  8. How to find current transaction level?
  9. How to insert multiple records and get the identity value?
  10. basic recursive query on sqlite3?
  11. How can a LEFT OUTER JOIN return more records than exist in the left table?
  12. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  13. Dynamic SQL to generate column names?
  14. Extracting hours from a DateTime (SQL Server 2005)
  15. Column name or number of supplied values does not match table definition
  16. How to split string using delimiter char using T-SQL?
  17. SQL Server PIVOT perhaps?
  18. How to find consecutive rows based on the value of a column?
  19. Custom aggregate function (concat) in SQL Server
  20. How to escape square brackets inside square brackets for field name
  21. Average of multiple columns
  22. What is the internal representation of datetime in sql server?
  23. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  24. how to increment integer Columns value by 1 in SQL
  25. How do I find the data directory for a SQL Server instance?
  26. Compare dates in T-SQL, ignoring the time part
  27. SQL: Aggregating strings together
  28. Distributed transaction error?
  29. SQL, How to Concatenate results?
  30. Determine what user created objects in SQL Server

Leave a Comment