N is the column name in my Tally table (dbo.Tally). Do you have a Tally table? If so, what is the name of the column in your Tally...

You are welcome.

Look up the Multicast transformation in BOL (Books Online).

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