this is the create statement for the source data (in 3 parts)

PART 1 (union of 2 views, one with order history and the other with open orders)

CREATE VIEW [dbo].[LCW2014Both_ONECOAST_SourceDataOpenHist_PC_NEW_2015]...

Okay, thank you Jeff. I fill first post the create statement for the staging table. Then I'll post the same for the source data (which is a SQL View).

...

Jeff Moden (12/18/2015)

---

ciskypete (12/18/2015)

---

Thanks for the reply Jeff! Would you possibly be able to explain this concept a little deeper? (as in, how I would go about setting this up,...

mister.magoo (12/17/2015)

---

pete.ciskanik (12/17/2015)

---

I have a staging table of customer names, numbers, and sales data etc. I've been trying to write a stored procedure that inserts everything into that staging table....

Thanks for the reply Jeff! Would you possibly be able to explain this concept a little deeper? (as in, how I would go about setting this up, or at least...