Hello one more time 🙂

i forget to mention that you may create your staging table with a Wizard.

The wizard will create ,for you, a staging table with all requisites (columns,...

hello,

there are several requisites to switch data in a partitioned table from an non-partitioned table (called staging/standalone table in Microsoft whitepapers).

You may read the whitepaper : http://technet.microsoft.com/en-us/library/dd578580(v=sql.100).aspx

For...