Data: Create a function for assigning rows in a table to partitions for pricing

[spenechap444]

When doing bulk loads, instead of having a trigger called on each insert, the end to end flow will involve deactivating the trigger, run the bulk insert, call a function to reassign the rows of the tables to the corresponding partition, then reactivate the trigger.

Prerequisites to this include having a function that dynamically creates sub partitions on a table. In order for this to be tested, there will need to be application integration to take into consideration.

[spenechap444]

Function created but still needs testing from application

[spenechap444]

This approach was flawed and only one function was required just to create the partition prior to inserting into the database. Once the partition is created then data can be inserted.