Associating Invoices With Projects: SQL Vs SPL
SQL Server database requires indirect implementation using nested subqueries & window functions to associate tables & add SplitAmount field according to rules. SPL code can be more natural with grouped subsets.
An invoice table in the SQL Server database has one amount for each project, and each project in the project table has multiple accounts, and the two are associated through ProjectID. Invoices Projects Now we need to associate the two tables and add a SplitAmount field. Roughly on average divide the amount according to the number of accounts in the project, for example, 100 is divided into 3 parts. The amount of N-1 accounts should be rounded to 2 decimal places according to 1/N, which is 33.33. The Nth account should complement the average value to ensure that the total amount remains uncha...