Viewing 12 posts - 31 through 42 (of 42 total)
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...
April 8, 2009 at 9:47 am
I have never used SSIS, can you point me to a good website or book for dummies that could help me out?
April 7, 2009 at 1:56 pm
The REPLACE worked. I had to convert to varchar first then do the replace.
Thanks for you help.
February 24, 2009 at 9:42 pm
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...
February 24, 2009 at 6:52 pm
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.
June 18, 2008 at 12:29 pm
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.
June 18, 2008 at 12:27 pm
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...
July 30, 2004 at 8:57 am
grasshopper and rockmoose....
thanks for your help. I got it working!!
July 8, 2004 at 7:28 am
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...
April 26, 2004 at 2:04 pm
Actually, I have not had a chance to try it as of yet. I will do so this Monday and let you know.
THanks.
April 24, 2004 at 10:34 am
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.
April 21, 2004 at 9:18 am
I was thinking about that but was wondering if there was anything I could do within 1 sql statement.
Thanks
April 19, 2004 at 12:29 pm
Viewing 12 posts - 31 through 42 (of 42 total)