GilaMonster (8/23/2011)

---

I wish.

When you get questions like 'What does <statement...

SQLDCH (8/23/2011)

---

I sent out a message through Yahoo, hitting this spot also.

We have 11 signed up, I'm going to go with 12 if the league doesn't fill by tomorrow. ...

It is a good question. I answered too quickly and got it wrong. Had I thought about it a little longer I would have remembered that an application...

A beautiful last day of work. I was able to sleep in, and when I did get up I did laundry, got my referee gear out and got ready...

Not sure, but are the last three entries in your post the expected results when processing is completed? If not, need that also based on the sample data.

Well, this is a good start. It would be nice to see what you have tried so far to solve your problem. That gives us a point of...

First of all, this is a professional site and comments like this are not acceptable. I hope this...

Let me clarify, what database maintenance tasks may have be done between backups?

First question, what other database activities were accomplished (manual, scheduled, or automatic) between backups?

Sneak peek didn't work, at least for me.

Evil Kraig F (8/15/2011)

---

Steve Jones - SSC Editor (8/15/2011)

---

Re: the MCM: This is a double edged sword. You don't need the other certs to sit for the MCM exam, and...

nageshp (8/13/2011)

---

Gail,

Am getting the same result when I select only col1 from both Left and inner join like the below

SELECT Tab1.col1

FROM Tab1

LEFT JOIN Tab2

ON Tab1.col1=Tab2.col1

or

SELECT Tab1.col1

FROM Tab1

INNER...

Per yout post, Tab1 has 1000 records and Tab2 has a million records.

An inner join between those two tables could generate anywhere from 0 records (no matches between Col1 in...

nageshp (8/13/2011)

---

In terms of performance which Join is best while updating the records.

I do have two table Tab1(at most 1000 records) and Tab2(1million records)

UPDATE Tab1

SET COL2=TAB2.COL2

FROM TAB1

LEFT JOIN Tab2...

I have to agree, and I am glad to see you to plunge and applied. Good Luck!