• Thanks for your patience Jeff. 
    I am fairly new to SQL. Having trouble getting my head around some concepts regarding Views. I see now that they can be Updated (updates the underlying table), as can CTE's, as you pointed out in another post. 
    Switching the View to one of the Staging tables, after a bulk insert of a csv file (& adding columns, shape the data, etc) I get.
    Having trouble with point 5 and 6. 😉

    How about:  
    1 copy data from Staging1 to Staging 2
    2 point Client view to Staging2
    3 bulk insert csv file, add columns, etc into Staging1
    4 point Client view back to Staging1

    J.