The problem with the trigger is that it doesn't tell the database what to do if there ARE matches, it just tells it what to do if there are not.

So,...

GilaMonster (5/15/2009)

---

Back to the subject of questions...

There must have been 8-10 questions on database corruption in the last week or two. Is it open season on corruptions all of a...

There's a security...

GSquared (5/15/2009)

---

There's a delete button above and to the right of the post. I know Steve had it disabled for a while, but I think he turned it back...

There's a delete button above and to the right of the post. I know Steve had it disabled for a while, but I think he turned it back on.

One of those was my first computer. 2k of RAM! Woot!

GilaMonster (5/15/2009)

---

GSquared (5/15/2009)

---

Actually, that looks more like an Asian elephant to me than an African one, judging by the ears. Possibly a female Asian elephant, judging by the lack...

Actually, that looks more like an Asian elephant to me than an African one, judging by the ears. ...

GilaMonster (5/15/2009)

---

And the continent visible is where I live, or more specifically, here

Not...

If they're all SQL 2005 or 2008, CLR should be able to do that for you pretty efficiently.

Zero latency is impossible in the physical universe. I'm assuming you mean latency so small you can't measure it, which still wouldn't actually be zero.

It'll depend on the bandwidth...

I recently turned 40, so I'm pretty much in the middle of my working life (assuming I ever retire or anything like that). I'd definitely say that the only...

What I've done for that was create a table in my DBA database and list the drives and their total space in that table.

I'm sure you can retrieve the data...

stoler (5/15/2009)

---

I thought about this, but problem is - I have more fields - and for every filds I must prepare subquery.

In MSAcces there is group function FIRST and...

mmunson (5/14/2009)

---

Thanks for the reply GSquared. I appreciate your opinion!

I continue to learn new functions based on the requirements from the users, and well, they can be pretty demanding!...