when you have multiple CTEs for one query you don't repeat the WITH keyword, you put each in brackets and separate them with a comma

If you give us table definitions...

So you never need to update the columns, or are assuming they never change?

What you described is a basic SSIS data flow. If you read the first 3 articles in...

Yes

You will need a dynamic cross tab or pivot to get what you want, which means using dynamic SQL

An article on how[/url]

Here is an example of the type of thing you are looking for[/url]

It used FOR XML PATH to concatenate the values, and STUFF to strip off any XML.

If you provide...

Once you do all that, you may also want to check for divide by zero in your finished query ...

Well, I am saying I suspect there might...

KoldCoffee (2/4/2015)

---

Hi Nevyn, In the early design phase of etl solution and I simply cut hours off the etl when I removed indexes. This allowed me to take a...

ITBobbyP85 (2/4/2015)

---

We have data that comes from a 3rd party in an Excel spreadsheet. We have successfully loaded that data to a staging table and now we have to try...

KoldCoffee (2/4/2015)

---

Must do a first time import millions of rows into a table followed by a daily import of much less (just the differentials since day before) after that. ...

After some light reading, I'd guess your issue is that the new machine has a different service master key, which won't work with your ssisdb master key.

Assuming you know the...

Ok, stupid question, why are you trying to use an excel connection manager to create a file you want to give the csv extension to?

Do you want a csv or...

This was actually sneakily trickier than it first appears, as showing the 0 level doesn't work with the recursion, and taking duplicates out is tough to work in with the...

So you are doing a 6 degrees of Kevin Scotch on the tables?

Also, does a match have to one scotch in common or all the scotches of the original...

I'm with Phil in that it seems strange that it would be right around 45 mins after deploying the change, and that I would first go through everything to make...