Personally, I think every table should have a surrogate key as either a Primary Key (PK) or Alternate Key (AK). Especially when using a natural key for the PK....

I won't (but someone else might). You need to try writing it first and if you have problems, show us what you have done and we will help you...

Paul_Harvey (3/10/2010)

---

Hi All,

Hopefully an easy one for somebody in "the know".

I have a table with some 75 fields, that acts as a staging table for incoming data feeds.

I want to...

Paul White (3/10/2010)

---

Lynn Pettis (3/10/2010)

---

Actually, the last 10 minutes or so of the game was quite exciting compared to the first 70 minutes. It took that save on the...

tstaker (3/10/2010)

---

Lol. I saw that thread. You all cracked me up. ...

Going to need more dynamic SQL for this. Here is a start on your search for the answer. the following code will help you identify the primary key....

Actually, the last 10 minutes or so of the game was quite exciting compared to...

Paul White (3/10/2010)

---

C'mon guys, think outside of the box! Ok, so warehouses aren't...

Sounds to me like an active database with many changes occurring after the snapshot is created.

Okay, brief synopsis of last nights soccer game, Coronado at Widefield. At the end of the first half, the score was Coronado 7, Widefield 0. Coronado scored 2...

Actually, I'd carpet the office area in the warehouse, just not the warehouse area itself.

I'd be curious to know why this where clause didn't work:

WHERE ( ord.OrderDate >= DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0) AND

...

GilaMonster (3/10/2010)

---

I'll give my standard answer here.

Memorising questions will not help you in an interview. An experienced interviewer can easily tell the difference between someone who knows the material and...

No assumptions needed. If you look at the syntax for creating a PRIMARY KEY, the default may be...

Please provide the DDL (CREATE TABLE statement) for the table, sample data (as a series of INSERT INTO statments) to populate the table and is representative of the problem, expected...