Thanks all, it worked when I added the date value in the Date dimension table (the primary key table) first before trying to insert it into the Facts table. The...

Evil Kraig F (6/15/2012)

---

I'd...

I had tried to clean it up using the following code, but it is still returning duplicate Date values:

SELECT DimCalendar.DateID, DimCalendar.Quarter, DimCalendar.Year, DimCalendar.Month, DimCalendar.Week, DimCalendar.Day

FROM DimCalendar

RIGHT OUTER JOIN (SELECT DISTINCT(DateID)...

PaulB-TheOneAndOnly (6/15/2012)

---

dj1202 (6/15/2012)

---

Hello all, I am creating a table, named DimCalendar, which has the following columns:

DateID (date)

Quarter

Year

Month

Week

Day

InvoiceNumber

There are duplicate dates in the DateID column, but I would like to assign...

Thank you MysteryJimbo. I don't know why I assumed all dimensions should have a primary key. I went ahead and assigned the InvoiceNumber column as a foreign key that referenced...

John Mitchell-245523 (4/26/2012)

---

What errors are you getting?

Actually, I would urge you not to split the dates into their constituent parts. Store them in the database as datetime, and perform...