Squirrel questions

Squirrel answers

• SQL Aggregate Sum to Only Net Out Negative Rows
• Condense or merge rows with null values not using group by
• Set count to variable
• Select distinct group of records only when all of the records' certain column is of a certain value
• Opening and Closing Balance Sum
• How to select and export 5,000 lines of debit and credit transactions at a time and have the debits and credits balance to zero?
• User defined table type with check constraint
• Pass Minus Values for a SP
• COUNT total by weekly and monthly SQL
• Update one table column values from config table using SQL subquery or dynamic query