Milan Sadil (3/12/2009)

---

Table1 - personID, firstName, lastName

Table2 - personID, badgeID, validFrom, validUntil

I would need to create a query that would result in the folowing:

firstName, lastName, badgeID

whereas:

- only valid badgeID (understand...

Nope, not too harsh in my opinion.

Unfortunately what you have does not work. Try it with the other criteria you stated earlier, it still returns 1.99.

Also, unfortunately, I don't have time right now to look...

Richard Briggs (3/13/2009)

---

Richard Briggs (3/13/2009)

---

Comrades,

as regards my own post on creating a CALCULATED PERSISTED column containing 'Age'.

I have discovered that actually because GetDate() is non-deterministic such a column cannot be...

Oh Boy! Double Posted Interview Questions that OP couldn't answer, here, and here

Really makes you want to jump right and help, don't it? 😛

Why rewrite things when you can...

It still needs to be a TABLE level CHECK contraint.

pklug (3/12/2009)

---

Yeah, my question was a bit vague; Sorry about that.

The basic operation of this will (should) be:

1. Customer selects a combination of 3 attributes, as shown in the...

frankivey (3/12/2009)

---

Yes...

Start with this and go from there:

declare @price table (

PriceID int,

UnitPrice money

);

declare @PriceGroup table (

PriceID int,

...

Nope. I still have BOL for SQL Server 2000 on one of my desktop systems. Read about SAVE TRANSACTION in BOL.

SQL Guy (3/12/2009)

---

I need to create a check constraint on a phone table.

This table has :

phone_id (PK, identity),

user_id (FK),

phone_num,

decsription,

is_primary bit

The rule is that only one...

I just sent "she who must be obeyed" the link you provided.

We'll see...

GilaMonster (3/12/2009)

---

It's available on...

JacekO (3/12/2009)

---

Lynn,

That's my point. The proper nesting is not supported by the SQL. Maybe it's because of the violation of the ACID rules but it is not there.

I ...