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

r.hensbergen (12/18/2008)

---

Jeff Moden (12/18/2008)

---

Nah... really? I thought the internet was...

Then I think it is official, the is the "Water Cooler" thread.

Have you tried putting the paths and names ("C:\Program Files\My Directory\Here is my file.dtsx") in double quotes? The command line does not like spaces in directory and filenames if...

Is that the entire query or just a snippet?

Also, could you post the DDL for the tables involved?