If you have a test system, I'd run a test. Try it both ways and see the time involved.

My son says this reminded him of me. Yikes.

http://is.gd/gkXJs

If you used the code or purchase a ticket by the middle of next week, you will have a ticket in your badge.

I think I'm with GSquared. Sounds like the person/position link needs just a FK in one table or the other.

you could use row_number to differentiate them, but it would be complicated to somehow determine that 66 is assigned to one person and 67 to the next, 68 to the...

you are referencing objects that don't exist.

What does this return?

select MyDate payrolldate from payroll

If it's the same error, then MyDate is not a column in this table. Pick a valid...

Which editor? As an FYI for me.

I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!

It seems...

I have a bunch of DVDs and ThinkGeek stuff so far. Based on registrations, it looks like an iPad is a real possibility now.

Not yet, but we're working on it.

I would say that Gus' suggestion of one big trigger allows you to see all the code, and perhaps optimize it. You might have a trigger designed for a certain...

Excellent

http://xkcd.com/810/

Each trigger adds to the transaction time since it is included in the transaction that is doing the update. That can impact performance as locks are held longer to complete...

David Stout (10/26/2010)

---

So much for early registration guess I'll be missing out on the fun. The code was not available when I registered.

PASS and use SSC2010 as the code.

Note that...