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...

Jeff Moden (1/6/2010)

---

Nice... I'm curious... why blog these instead of submitting them...

That is a new date/time data type introduced in SQL Server 2008.

Based on the sample data:

insert into users values ('john','doe','test@test.com','N') -- ID 1

insert into users values ('john','doe','test@test.com','N') -- ID 2

insert into users values ('jack','doe','test@jack.com','N') -- ID 3

insert into users values ('jack','doe','test@doe.com','N')...