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...

Do you mean across the whole twelve months or just 11 or less in any one month?

One...

Depends on what you mean by working fine. You are stepping into the unknown and items like what...

spidey73 (11/28/2016)

---

I thought I found the cause of the issue but NO. But I still was astonished.

When you create a SSIS package, you create connection managers.

These connection managers and the...

The casing is taken into accounts with names of the worksheets? Though I believe this would produce an error still good to be sure. And the list(s) in that fifth...

The DATEFROMPARTS function does not work in the 2008 edition.

As an alternative ...

declare @fromDate date, @toDate date ;

select @fromDate=

dateadd(m,0,cast(Cast(year(getdate())-2 as char(4)) as date))

select @toDate = cast(getdate() as...

mugilanoracle (11/29/2016)

---

hi,

please tell me how to export sql server single table into multiple excel sheets in single Excel file using SSIS package.(ex-have region column in source table and have to...

Ed Wagner (11/30/2016)

---

Yes it does....