Well, Jeff has braved it but didn't comment on the normalisation bit of the...

It's pretty dificult to make recommendations when there's a dearth of detail as to th erequirement, but as Jeff didn't attack your point 5 (on normalisation) I will. I'm...

That "know...

Several people have stated that BI edition supports this feature, ie Microsoft's BOL documentation is wrong. Could someone who is in a position to know this for sure (I'm...

Even today the Latin word tabula is sometimes used in English, for example in the phrase "tabula rasa" (an erased slate - or an empty table :-D); in Latin, it...

Interesting. It's good to see that the stuff some of us were trying to do quarter of a century ago has finally been done.

Oracle's OPS was an attempt to...

I agree with that. Having time but no...

It would certainly be an interesting excercise, and potentially produce a case study that would help a lot of people. It would be particularly interesting to see what recovery...

scratch

Luis Cazares (5/23/2014)

---

As Sean said, datetime data types don't have format. If you define your column type in your flat file connection, and insert the value in a datetime column,...

I interpret the question differently from earlier posters, maybe the following code is what you are looking for:

with TotalSales as (

SELECT T0.ItemCode, SUM(T0.LineTotal) as [Total Sales]

FROM...

SQLRNNR (5/23/2014)

---

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can be partitioned....

Board

Lynn Pettis (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that...

happycat59 (5/22/2014)

---

+1

With...