rdavid-773903 (3/23/2010)

---

Thanks to all three who responded, where the common theme was providing some easy to use data for you to look at.

Well, as so often happens, a combination of...

googoo eye

Dead-eye?

igngua (3/23/2010)

---

thanks!!

it worked!

select t1.cotnum, t1.codaux,

t2.cotnum, t2.codaux

from hermes.lab0708.softland.nwcotiza t1

left join softlandsoporte2.softland.nwcotiza t2 on t1.cotnum = t2.cotnum

where t2.cotnum is null

Now i´ve to update T2 with all the columns from 1...

GilaMonster (3/23/2010)

---

Paul White NZ (3/23/2010)

---

Who?

(now where's that new angelic...

Garadin (3/23/2010)

---

Heh, no, you mistook me. I wasn't cranky at all. I was joking around with them all being buzzkills with the 'already knowing it' and letting you...

"Bart Simpson, who the hell are...

GabyYYZ (3/23/2010)

---

GilaMonster (3/23/2010)

---

Dave Ballantyne (3/23/2010)

---

Not odd, ive always thought the exams are based around , can you remember obscure syntax for obscure functionality used once in a blue moon....

mbricker-600840 (3/23/2010)

---

Sorry...

How about...ummmm...

WayneS (3/23/2010)

---

CirquedeSQLeil (3/22/2010)

---

I also believe the same could easily be said about people with College Degrees. There is a person in our finance dept that got a degree in...

Gianluca Sartori (3/23/2010)

---

ROTFL! :hehe::hehe::hehe:

Jason, I don't want to be unrespectful, but, looking at the quite high number of wedding anniversaries...

Tara-1044200 (3/23/2010)

---

the log file is as much as usual database size, i think though it is in simple mode if the transactions are not cimitted it will grow big.

what would...

Excellent topic and excellent article.

Thanks Lowell. This is very useful stuff to have in the tool-belt.

stink-eye

Correct, the insert must finish before you can...