patricklambin (3/5/2015)

---

Why the b) choice ( truncate BBB , delete AAA ) is not correct ?

It seems for me that as soon as there is no more rows in...

That's not a typo, that is a mistake.

DELETE FRAM BBB, that is a typo.

Nice question, unfortunately poorly implemented.

P Jones (3/5/2015)

---

That said we do often import spreadsheets in SSIS, but you have to remember that the excel connector decides the field types based on the first ten rows...

winston Smith (3/4/2015)

---

Martin Schoombee (3/4/2015)

---

winston Smith (3/4/2015)

---

We are figuring what type of data constitutes master data for our organization. At present we are dealing with just one entity - Person.

A...

Interesting question, thanks.

Maybe you should add a WHERE clause to your UPDATE statement?

Update TableB

Set Description = ?

WHERE TableB.Key = ?

In the second parameter you map the key that needs to be...

Nice question, thanks Steve.

erics44 (3/3/2015)

---

Luis Cazares (3/3/2015)

---

Koen Verbeeck (3/3/2015)

---

Keep in mind that you are connected live to that SSAS database.

If...

My first thought is that you need some sort of matrix, where the first three columns are fixed and everything after Owner Name (thus the Incentive columns) are just one...

Jeff Moden (3/1/2015)

---

The fun part will be when they add a month between March and the Total. Would that be "self realizing" or what that require a change to...

Keep in mind that you are connected live to that SSAS database.

If you make changes in BIDS,...

If you want to develop reports for SQL Server 2012 it is adviced to use the Visual Studio 2010 shell.

You can find this on the SQL Server installation media under...

What kind of jobstep is this?

Mwoehahahahaha, home alone!