And here I thought ON and JOIN were the exact same thing 😀

Nice question, thanks.

diwakarjha.80 (11/7/2014)

---

Sergio, thanks for your suggestions. Indeed there are different ways to show the new customer count for different scenarios. What I am unsure is should NewCustomer column be in...

Be aware that those are special quotes in the CREATE TABLE statement.

` is not the same as '

Ah, so not a permission issue after all 😀

Brandie Tarvin (11/7/2014)

---

Can someone please help me here? I am having a very bad week, so I'm about to lose my temper with Stewart because he wants to focus on...

Does it already fail in BIDS?

And what are the exact errors/warnings that you encounter?

Is the package stored on the machine itself, or on a UNC path?

MMartin1 (11/6/2014)

---

There is also the 2208 SSIS book written by Knight and team. Professional Microsoft SQL Server 2008 Integration Services (Knight, Veerman, Dickinson, Hinson and Herbold) from Wrox. It is...

diwakarjha.80 (11/7/2014)

---

Yes, adding a column in fact table and setting its value to 1 can be a solution when the customer is counted new only for once in the lifetime....

The way we did at our current project (where we also have a snapshot fact table) is to add a measure to the fact table: NumberOfNewCustomers.

This simply contains 1 if...

How do you determine new customers? And when does a customer stop being "new"?

OK. Is it possible to give some sample data and the desired output?

Hmmm. Can this query lead to...

Sean Lange (11/6/2014)

---

I am back. Had a major project get deployed 2-3 weeks ago. This was a complete top to bottom rewrite of our ecommerce system that took nearly 2...

Which tool are you working with?