General SQL Hints and Tips

Do a running total using Sum (x) Over  Sample Code: select 100 * (crContractVal...
Wed, 17 Jul, 2019 at 2:07 PM
Using Cross Apply to get data out of function or subquery  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