These are actually Great Plains databases that I need to move from one server to another overnight. The problem is there are over 100 databases from 2mb upto 2gb in...

I have never used SSIS, can you point me to a good website or book for dummies that could help me out?

The REPLACE worked. I had to convert to varchar first then do the replace.

Thanks for you help.

What i am actually doing is putting the column into an email message sent via sql from my stored procedure.

I am using HTML as my format.

When i receive the message...

Noel,

They do have the reporting database partitioned, but I believe it is partitioned by day (24 hour).

We were originally going to partition by year, but it didn't work out.

Thank you for your replies, I am going to do some homework on both your suggestions and present something to the other staff members based on those suggestions.

Adobe is fine but I don't have adobe writer.

What I meant by distribute was that I need to send these schemas to our customers and most likely all they...

grasshopper and rockmoose....

thanks for your help. I got it working!!

Thanks to MikeyMikey's suggestion I got it to work..This is a simplied version.

I have an employee table and an employee_region table. Not every employee will have an employee_region row.

My problem...

Actually, I have not had a chance to try it as of yet. I will do so this Monday and let you know.

THanks.

That is what I was shooting for, but I wasn't sure if I was able to use CASE statements in the JOINS.....

I will give it a try though.

Thanks.

I was thinking about that but was wondering if there was anything I could do within 1 sql statement.

Thanks