Have you verified that you get every row and that it doesn't just toss a bad...

Just as a knee jerk reaction, and with no sample data etc to go on, I'd think it was your isnull datetimes throwing off the use of appropriate indexes.

If it's...

yup that's true the NULLS would be in there. See what happens when I get a bit ahead of myself... also, good to hear you actually have the data...

I just remembered the bit about it working fine in DTS Designer but not DTSRUn. any chance they are using different versions of the same driver? when I...

Sounds like there could be some kind of funny character in that column somewhere...

I ran into a similar problem using an RMS database as an ODBC datasource. There were...

This seems like some sort of health care bit, so perhaps you might not have the ability to do this, but just out of curiosity, how's come you have 4...

Of course that brings to mind the whole concept of repeating groups and such but if this is going to a report or a front end piece or some sort...

Any reason why you're doing this in a function and not just as a straight select statement???

You can get the same results with something like

SELECT diagnosis1 +

CASE WHEN diagnosis2...

When you are viewing it in VS are you viewing it in Print Layout or web layout? Make sure that whatever size paper you specified that our report doesn't...

you should be able to script you logins out of the 2000 server and when you create them in the 2005 server, they need to be synched back up with...

what about permissions, does the account you are logging in with (and connecting to Config Mgr with) have admin right to the Server to stop and start windows services? ...

That was gonna be my next question.. Is the WMI service started? what happens if you restart the WMI Service. What happens if you restart the server?

-Luke.

Besides at like $50 per (retail) it's not that bad... you can perhaps even get it a bit cheaper via volume licensing.

-Luke.

From http://www.microsoft.com/sql/editions/developer/default.mspx

Developer Edition allows developers to build and test any type of application with SQL Server on 32-bit, ia64, and x64 platforms. Developer Edition includes all of the functionality of...

any chance whoever installed it just installed the tools instead of the actual server components?

Are they listed in the Services console?

-Luke.