I have to agree. Being...

Greg Martin-419640 (1/7/2010)

---

Hello and happy new year everyone.

I've looked in the thread and not managed to see an answer to this. I use SQL server.

If I have a Customers table,...

Really? Try this please after removing the space from between...

Oksana March (1/7/2010)

---

Bru Medishetty (1/7/2010)

---

The_SQL_DBA (1/7/2010)

---

Bru Medishetty (1/7/2010)

---

You can start creating databases...

Assuming you have a Tally table, how about the following code:

declare @ TestData varchar(12);

set @TestData = '03EA12J77';

select

(10 - (sum(

...

Or this:

declare @ThisDate datetime;

set @ThisDate = '2010-01-05'

select dateadd(mm, datediff(mm, 0, @ThisDate), 0) -- Beginning of this month

select dateadd(mm, datediff(mm, 0, @ThisDate) +...

I think you are missing the point of our questions. In your sample data, there are two duplicate users based solely on first and last name; John Doe and...

What is the full error message that is being returned.

CirquedeSQLeil (1/7/2010)

---

I have a male friend named Kim and another male acquaintance named Shannon - so I will go with male on those.

Lynn, if...

Jennifer Levy (1/7/2010)

---

Excellent point. A lot of the problem...

Okay, two questions. Regarding John Doe (ID 1 and ID 2), how do we know ID 2 is correct, because the ID number is higher? Second, in the...

Yes, very interesting article. Here is...

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.