ajreynolds (1/7/2010)

---

The goal was to try to speed up the process by eliminating an extra query. I'm no expert on SQL, but I would think that combining into...

I agree. I have a feeling we are only getting a piece of the puzzle, not the whole puzzle.

Missed that, good catch.

I am an absolutist, never say never.

Ray K (1/7/2010)

---

pgatte (1/7/2010)

---

I am new to SQL.

Can you tell me how I would convert a DateTime field to MMDDYY without any / or .

Example I would need...

I think that should be NOT LIKE.

Please understand, ISNUMERIC is not the same as IS A NUMBER. The following, select isnumeric('1e1'), returns 1 as the value can be converted to a valid numeric value.

If you...

Bru Medishetty (1/7/2010)

---

You can start creating databases one by one until it...

IIRC, *= is a left outer join, =* is a right outer join, *=* is a full outer outer join.

You really should have used PM to send your email address, now it is out there in the cyberworld.

cmcc (1/7/2010)

---

...

Women, you know how rewarding this field is. Please reach out to the ENTIRE next generation and teach them that this is a great field to be in, and...

Yes.

It would help if you provided the table definitions (CREATE TABLE statements), sample data for the tables (as a series of INSERT INTO statements for each table), expected results, and...

VaporStorm -- We got the cold but nothing else.

My youngest (11 yr old) told me about a conversation that she and my wife were having at my wife's office this afternoon about computers. I don't fully recall...

Thanks. Seemed the simpliest way to shift the data the appropriate number of "spaces" to...