Home Forums SQL Server 2008 T-SQL (SS2K8) Update by rank using subquery RE: Update by rank using subquery
philip_egan
SSC Journeyman
Points: 97
More actions
October 25, 2013 at 6:53 am
#1661611
I think I've sorted now thank you - Just finalising and I'll post details but I'm putting the payments and their row numbers in a second temp table and then using an update to marry up the temp invoices and temp payments