Brandie Tarvin (8/27/2010)

---

Wow, Wayne, that's a majorly cool solution. I like.

The only concern I'd have is scalability, but that's dependent on what the other countries' docs "look like."

EDIT: Then...

WayneS (8/27/2010)

---

Jack,

In looking at the I-9 form from your previous link (2nd post in thread), I see something that might help you out:

You need to produce documentation that

1. Establishes...

The Dixie Flatline (8/27/2010)

---

Hey Jack, I have a thought, but first I need to know the maximum documents would you ever expect to be joined in an "AND" condition? ...

Hi, my name is Jack and I used to think I was a DBA. Actually do more dev both in SQL and .NET than DBA work. DBA work...

Brandie Tarvin (8/27/2010)

---

Jack,

I'll look at the script as soon as I get some free time, but real quick... I know this is a taboo thing to say amongst DBAs, but...

Okay, I'm back and that means more questions.

Basically using Bob's solution. My 2 validation tables are: Citizenship_Document_Requirements and Citizenship_Document_Requirement_Rules

I've attached a script that has the needed tables and limited...

CirquedeSQLeil (8/26/2010)

---

So here is my question of the day

How do you convince somebody that archive data should not be changed?

Data integrity didn't work

Point in time visibility did not work

Reporting consistency...

Roy Ernest (8/25/2010)

---

Great Job Paul... Way to go. 🙂 Your blog is on fire.

@jeff. I never set up the netmeeting. I am going to see how that can be...

Jeff Moden (8/25/2010)

---

When you figure it out, send me an email and...

Bob,

Really liking your idea. I'm assuming the alternative column means I need each document with that alternative. I think this is a little more complex than what I...

Okay, thanks for comments, questions, and code. It's not really a constraint. This table or tables possibly, is needed so we can enforce business rules. Basically a...

I posted this question yesterday and haven't gotten any response so I thought I'd put the link in here.

Update on this especially since I haven't gotten any help yet. Essentially trying to model the requirements on the U.S. I9 form (link is to a pdf).

Any and all...

I don't want to get a contact list out, I want to get a contact list in. Can you do that?

As Grant said it is highly unlikely that the system time on a server be reset. I'd be more concerned with the change from DST back to Standard Time....