Ah yes, that could be handy. LAG/LEAD would be useful too (access the previous/next records values) just a shame my company is still on SQL server 2008
Going to have to look into LAG/LEAD and CONCAT/FORMAT but from that list, I use APPLY a lot. If you tend be using loops a lot, look into tally tables,...