I think my cool project days are over. Some interesting stuff with cars, radar and other control software. Most of my projects now are Data warehouse and BI. That used...

Thanks.

so thats all my plans out the window and look at Checkpoints. Would it be sensible to force checkpoints if they are not happening quickly enough?

I have had the same...

TheSQLGuru (8/23/2013)

---

DOH!! TOTALLY forgot to mention the transaction log! You need to manage that carefully or you can fill up the disk pretty easily (or at least wind up...

Many thanks for that.

Mark

Ok,

I get it. I have done a very similar situation. The easiest solution is to include the employee id on the fact table.

DSV's require a straight forward join so there...

You can bring in the text about the charge. It is possible for the FACT table to also act as a dimension table. Basically you create a bnew dimension based...

As I have the MERGE in a stored proc I was considering passing in a couple of parameters and using the WHERE clause in the SOURCE element of the MERGE...

Need far more info.

Show us roughly what the tables look like

Show us what (and why) you are trying to achieve

Cheers

E

Thanks.

I have not decided what to do yet. As there will be a significant overhead to doing the count we will need to consider if the information gathered is who...

Thanks,

I was hoping miraculously that I had missed some extra functionality within the emerge statement.

Two separate transactions it is then.

Cheers

E

Many thanks but I read that George posting the question. I can't see a way to get the number of potential deletion a unless I execute the delete command and...

Ok

not too clear hear what you are trying to do but

In that error message it refers to Analysis Services 9.0.242.0 . This is 2005 version so that does not...

In addition I would add that if you show signs of taking charge of your own training and development it shows that you have a commitment to your career. I...

Think its the column delimiter

When on the columns tab of the source connector you will see an option for column delimiter - its a drop down. But you can click...

Checked and works.

You would have thought tha MS would consider that there should be an additional option to the normal SQL comparison operators to allow to compare against a NULL.

Would...