Thank you for the suggestion. right('0' + cast(ST.GR as varchar(2)), 2) works outside of the CASE, but not within the CASE. The same holds true for '0' + Cast(st.gr as...

Thanks to all for your help!

CSDunn

Thank you for your help. I'll try the set up with a SQL Account.

CSDunn

Thank you for your help. After I posted this message, I found the information about setting up a linked server. I tried it, and ran into some problems.

Please see...

Thanks for going the extra mile to assist. I really appreciate your help!

CSDunn

Thank you for your help, I will try this against a temp table.

CSDunn

Neal,

Thank you for your help!

CSDunn

No luck. When I tried the variable assignment as you prescribed, I got the following error message when I attempted to 'Alter' the procedure:

Server: Msg 141, Level 15, State 1, Procedure MM_G1_SFMath_A_EOY_AUTO_sp,...

Thank you for your help, I will try this.

CSDunn

Thanks, I will try this. I was able to do something similar by using my CASE stmt in a view, then joined to it by StudentID and TestDate in another...

As it turns out, I spoke to soon, this did not work.

Does any one else have and idea on this? I'm still trying some things.

Thank you!

CSDunn

It looks like if I handle the TestDate field in a CASE statement as follows:

"MaxDate" = Case

When Max(TestDate) is not null then Max(TestDate) End

The I get the result I was...

Thanks to all for your help. I came accross the following MS Knowledge Base article; http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql2k#5 . This article gives detail on how to move databases between instances of SQL...

Thanks for your help. I ran the update, and it worked. I can see from the properties of any given Job that the source has been changed to SDO-SQL. However,...

Thank you for your help!

CSDunn