Have you tried doing a RESTORE DATABASE?

A *.BAK file is usually a full backup (not always, but usually).

ppcentral (4/26/2012)

---

Thank you for the reply!

Ok... I missed the quantity sold, but the doubt still present.

CASE 02

Date Customer TransactionIDProductIDQuantitySales Ammount

20120101CLI01FAC0005PROD013300 €

20120101CLI01FAC0005PROD022500 €

20120101CLI01FAC0006PROD011100 €

20120101CLI02FAC0007PROD015500 €

20120102CLI01FAC0008PROD014340 €

20120102CLI02FAC0009PROD016560 €

The question is objective... Which...

ROFLMAO!

Definition of Clueless.

But do not fear, he will solve his problem.

MisLead (4/26/2012)

---

Lynn Pettis (4/26/2012)

---

MisLead (4/26/2012)

---

Lynn,

Business Case is Simple. We have data flowing from a system that supports Unicode to the system that does not support Unicode and only supports ANSI...

ppcentral (4/26/2012)

---

The CASE 02 is the fact Table that has the more detailed data... And from them you can see that the count of products from each order(transaction) is

FAC00052

FAC00061

FAC00071

FAC00081

FAC00091

Correct?

Now, you...

Steve Jones - SSC Editor (4/26/2012)

---

Current QOD status. I have them scheduled through May 9, plus a few random days out past that, but I also have 16 submitted right...

PaulB-TheOneAndOnly (4/26/2012)

---

ppcentral (4/26/2012)

---

Dear friends,

Today I post another issue related with Kimball Fact Table Types...

The following cases are two examples of Fact Tables in a dimensional model. Which Fact Table Type...

MisLead (4/26/2012)

---

Lynn,

Business Case is Simple. We have data flowing from a system that supports Unicode to the system that does not support Unicode and only supports ANSI standard characters. what...

I have to ask, what is the point of this question?

Freedom!

L' Eomot Inversé (4/26/2012)

---

You shouldn't mention that here - young innocents may read it.

That programming language is suitable for Kobolds and Galgenmänner...

Just so you are aware, since your clustered index is on FK1, FK2, FK3; when you get a clustered index scan, you are actually scanning the table.

It depends. What do you mean by access? The purpose of a database to facilitate multiple user access while maintaining the integrity of the data.

opc.three (4/26/2012)

---

MisLead (4/26/2012)

---

opc.three (4/26/2012)

---

I think MisLead (ironic name given the conversation, no? :-D) wants to store the data as NVARCHAR, but wants to provide an interface for this legacy app...

Actually, I think that is backwards. ...