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...

Can't even start to help you. Please post the complete error message you are receiving when the SSIS package is run as a scheduled job.

I have to agree, it looks like you are doing well. All you can do is learn what you need when you need it, and know where to look...

The N in front of a string like this, N'A String Constant', is a UNICODE string. You can find more about these in Books Online, the SQL Server Help...