Well, if we ever had IT, I think we lost IT. If anyone has found IT, please return IT.

Thanks! :w00t::P:w00t:

No, no, no. It's "Thank you, now let's go out for a drink or two or ..."

Then you did something wrong, because I just cut and paste the code from my post here at home and ran it. ...

Why did you have to use a DISTINCT? My code returned exactly what you requested, based on your sample data 62 rows.

I'm glad to see that you have a sense of humor! It is needed around...

Your database and/or server is using a case-insensitive collation, therefore 'dd' = 'DD' is true. You could do something like this:

'dd' collate Latin1_General_BIN2 = 'DD' collate Latin1_General_BIN2

You are comparing apples to oranges when comparing the action of REPLACE with UPPER. REPLACE doesn't know how big the returned string is going to be when the replacement...

Windows Server 2000 may not run on future physical hardware, but you should be able, if needed, be able to install Windows Server 2000 on a virtual server.

In fact, you...

Did you happen to take a full backup of each of the databases prior to detaching them to move them to a new server? If you no longer have...

Like I said, it's all Greek to me! 😛

srathna77 (12/18/2008)

---

Datatype for no email is bit in customer table i wnat to include this in a case statement.

SELECT

CASE

WHEN NoEMail NOT IN

(select emailaddress from Reports.dbo.OptOutEmailAddresses)

AND

substring

(Customer.Email,...

Here you go:

create table #client(client_id int, schedule_date datetime)

insert into #client values( 301, '2008-1-21')

insert into #client values( 301, '2008-1-30')

insert into #client values( 302, '2008-1-15')

insert into #client values( 302, '2008-1-21')

create table #date_dim(day_date...

So you also need to pivot the data for the report?

Also, with the rows where dates look like 2008-12-01 null null, how do you know which one belongs to which client?

I did, and I asked why you need all the extra duplicate rows where you have 2008-12-01 null null?

Care to answer the question I asked? Can't help if...