General SQL Hints and Tips

Do a running total using Sum (x) Over
https://codingsight.com/calculating-running-total-with-over-clause-and-partition-by-clause-in-sql-server/  Sample Code: select 100 * (crContractVal...
Wed, 17 Jul, 2019 at 2:07 PM
Using Cross Apply to get data out of function or subquery
https://explainextended.com/2009/07/16/inner-join-vs-cross-apply/  Example of use. get latest price from Tenders. select t.sgOptionName, b.croptio...
Wed, 17 Jul, 2019 at 2:37 PM
Use Concat to put strings together that might contain nulls
example if you need to work with things like lot address:
Wed, 17 Jul, 2019 at 2:42 PM