This is what I came up with. Please note, that if there is detail, you don't have a date to do any comparisions.

select

m.Client,

...

The same can also be said about a truely...

J (3/17/2008)

---

Comments invited.

You could also calculate ONCE the "10 +" dates -- when crreating the record.

True, you would need an additional column (AARG! Thrid Normal Form Violation ! do NOT...

I have looked at the two files with CREATE Table statements, and I'm not going to do anything with those as it is too hard to see what's what. ...

To give a more correct answer, I think we need more information about the tables and the data. We have just about enough info to give a swap, but...

Short answer, no. You can not attach a database from SQL Server 2005 to SQL Server 2000.

😎

I also don't think it would matter in an index if the 1.5+ million rows of null in column4 were set to a default of 0 either. It would...

This query will be slow, you are only checking column4 to see if it is null,...

It would help if we could see the query (or queries). Also, are there only 4 columns, or are you you telling us about 4 columns. The DDL...

Hopefully that will work. Curious why an image field was used to hold a text blob instead of a text or ntext field.

Try building a view over this table. In the select statement for the view, do this for the image field:

cast(image_field as nvarchar(max))

And then use the view as your data...

Okay, so it isn't similiar to replication. Good thing to know.

Thanks

😎

Looks to me like a dual boot system. Only one can run at a time, so I don't see how he is going to get what he wants.

😎

Part of your problem could be the two corelated queries in the select statement.

Try this code and let us know if it work and still returns what you expect:

select

...

What is the base type of the blob in the source database?