Understanding Multiple Looping with SQL Query Functionality in PowerShell

Understanding and Working Around Variable Scope Limitations in PowerShell's Foreach-Object