Still, going the negative number route will likely only buy an addition year of time according to what was forecast by the OP. (18 months total... 6 months for +,...

Heh... even worse... all we really need now is for Joe Celko to jump in with his ISO standard mantra... 😀

Ok... it's a fun exercise, but I've gotta know... why did you folks decide to do one in SQL? I mean, what do you actually use it for? ...

I've seen all 3... but I think it's a mistake to do anything other than #1 and that's what we do at work. DBA does a backup just before...

Apprently,...

And thanks for the feedback.

Heh... yeah... I know a really good one 😉

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

You bet, Rishi... thank you for the feedback.

That's pretty much true, Matt... I'm amazed at what people think a DBA is supposed to do... no wonder it's so hard to find that type of job in Michigan...

Matt Miller (3/5/2008)

---

Jeff Moden (3/4/2008)

---

Ok, no... you have to use NEWID() to populate the column. It is NOT a self populating column. Then, you would check for an...

Thanks.

GilaMonster (3/5/2008)

---

No, because using functions on the column in the where clause means that SQL cannot use an index seek to locate the rows, and it will have to scan.

OR...

sgivoni (3/5/2008)

---

Not entirely...

admin (3/5/2008)

---

Jeff Moden (3/5/2008)

---

And, no... I'm not making fun of anyone who uses DTS... if you take it that way, then I apologize. I'm just saying I've always...

paul.ibison (3/5/2008)

---

Thanks Jeff. The name makes sense but I can find no reference to it. Can you provide a link to the "mixed rowtype" definition (search for "mixed rowtype" in...