[Script Of Jan. 17] How to sum the child nodes for a parent node in a SQL Server table

  • Article

image

Jan.

17

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-sum-the-child-nodes-9430fb12.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This script is to sum the child nodes for a parent node in a SQL Server table.

As some people asked how to get the sum of total child nodes for a parent node, this script will demonstrate how to do this by creating a sample table.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery