Squirrel questions

Squirrel answers

• 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
• Fill in gaps in data, using a value proportional to the gap distance to data from the surrounding rows?