Father, husband and general problem solver who loves coding SQL, C#, Salesforce Apex or whatever.
More bio"Keep learning, or keep smiling; there is nothing worse than a sad fool..."
====================
A SQL Tidbit: Articles
====================
A SQL Tidbit: Conditional Aggregates - https://www.experts-exchange.com/A_3527.html
A SQLite Tidbit: Quick Numbers Table Generation - https://www.experts-exchange.com/A_3570.html
A MySQL Tidbit: Quick Numbers Table Generation - https://www.experts-exchange.com/A_3573.html
A MySQL Tidbit: In-line XML Parsing - https://www.experts-exchange.com/A_3574.html
A MySQL Tidbit: In-line CSV Parsing - https://www.experts-exchange.com/A_3622.html
A MySQL Tidbit: Dynamic Export To_XML Stored Procedure - https://www.experts-exchange.com/A_3638.html
====================
Articles I Refer to Often
====================
Analytical SQL : Where do you rank? - https://www.experts-exchange.com/A_1555.html
Dynamic Pivot Procedure for SQL Server - https://www.experts-exchange.com/A_653.html
by mark_wills - https://www.experts-exchange.com/M_4390378.html
Pivot Rolling Periods Without Using Dynamic T-SQL - https://www.experts-exchange.com/A_654.html
Broaden Your Horizons : Pivot Again! - https://www.experts-exchange.com/A_1537.html
3 Ways to Speed Up MySQL - https://www.experts-exchange.com/A_1250.html
by gr8gonzo - https://www.experts-exchange.com/M_124884.html