Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: accumulate

Accumulating values in a parent-child hierarchy

Last week, we looked at how to construct a visual representation of a hierarchy stored as a parent-child table. The obvious next step is to accumulate values stored on those nodes using this hierarchy.

Continue reading Accumulating values in a parent-child hierarchy
Published 2014-04-06
Categorized as Intermediate, T-SQL Tagged accumulate, aggregate, balance sheet, child, hierarchy, income statement, parent, ragged dimension, recursive
sqlsunday.com
Proudly powered by WordPress.