cad.delworth (6/1/2016)

---

Just the smell of coffee makes me want to vomit (literally).

Any workplace that has a coffee machine dominating it, is somewhere I will definitely NEVER take up a job,...

What 'logic' do you want to apply? What are you trying to do?

I suggest reading this article, and posting DDL for your table, some sample data and expected output as...

I would usually redirect any rows causing errors into an Excel file, and attach that file to an e-mail task. (Of course, not forgetting cleanup phases so that we don't...

What are you struggling with? I'm not sure I understand.

If you're stuck implementing the parameters into your code, you use the parameter in place of a value.

E.g if we have...

Sean Lange (5/13/2016)

---

tindog (5/13/2016)

---

Sean Lange (5/13/2016)

---

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate. I...

Sean Lange (5/13/2016)

---

Luis Cazares (5/13/2016)

---

ChrisM@Work (5/13/2016)

---

Sean Lange (5/13/2016)

---

Brandie Tarvin (5/13/2016)

---

For those who hadn't heard, THIS happened.

Yay.

EDIT: I should add I'm not trying to start a debate. I just wanted to...

Sean Lange (5/13/2016)

---

IMHO people...

:w00t:

Is it necessary to post this on so many old threads?

Plot twist; I tried upgrading the same project but from a different server and it worked.

But still lost settings for SCD tasks...a great annoyance but not a major life crisis.

OK I'm having a quick stab at this again and my SSRS projects all upgrade with no problems.

This is driving me mad.

A bit of a stab in the dark but have you tried deleting the .suo file? (Close the solution first) If it's a straight upgrade and nothing else has changed...

I would have probably made the calendar table to include date, year, month, day of month, days until month end etc. Then you could join on date to get the...

No problem!

For a refresher of the various aggregates and their jobs, check out this page: https://msdn.microsoft.com/en-gb/library/ms173454.aspx

Why can't you remove duplicates? What is their purpose?

You can add an incremental ID, make that primary key. 2 duplicate rows cannot have the same PK however, it must be...