Thanks for the feedback Kevin. That looks like a star schema coming together now. What about the account type? That can be an attribute in the account dimension. As far...

You may want to archive...

JesseBizInt (12/12/2016)

---

In my environment I have many different departments that need to be kept separate from each other, yet share some data elements such as calendars and employee profiles. ...

I would bet this is the type of situation where the script is easy and fast to run and the fix is complex to where they keep putting it off...

Do you have any index on...

spidey73 (12/6/2016)

---

The job step runs with a proxy. The account used in the proxy/credential is a domain account with privileges on the folder, but NO privileges on the server on...

Referring to the article on the calendar table, you could add a [month] column that would makes this easy for you.

You would create the field and update it by...

Just does not come across to me as a good idea. That should be defined and referred to in your ETL process.

I think it is a good idea to keep the business ID along with your surrogate key definitely. As far as the source, that sounds to me more for auditing...

I am also assuming that the odoReading (mileage) increases with time , we are talking about vehicle miles correct?

I think you may have to keep track of the vehicle as well?

If you dont mind doing it the old fashion way (pre Lag() and Lead() ) here is a...

You can also opt to display your results to TEXT (rather than the default grid). The nature of a cell is such that the value takes priority over the...

It makes sense to me to have these functions in their own database so as to keep a consistent definition of them in one central spot. Keeps you from having...

See if this is helpful to you .

https://msdn.microsoft.com/en-us/library/ms186329.aspx

The article has an example that makes use of a audit table. I have to wonder if you are not concerned about...

The problem may be that you are also creating a table inside the inner stored procedure ( with the same name I presume). In these cases each object is local...