Since all that was involved was division, addition, and multiplication; I was able to identify the correct answer without testing or reading, the order of precedence for /,*.+,- is a...

The table DDL, some sample data (in the form of UNIONed INSERT statements), and expected output based on the sample data will help us help you figure out what you...

In my query, I assumed that those are variables, so I replaced them with proper variable names even though I left out the declarations for them.

😎

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

😎