I tried to guess structure of the tables, unfortunately it is impossible to know from which table the columns CoverChrgAmt and CalcTotalReimAmt are. I placed them into the table Reimburse and...

Hmmmm... the question was "Are some tables modified more often than others?". I guess this is a hint to the possibility to divide the database into several files/filegroups, with separate...

Yeah.. and since when the posted SQL returns 12/1/2005 12:00:00 AM? At least for me it returns

2005-12-31 23:59:59.997

Anyway, it seems that question was how to strip the time part away from result,...

I suppose that by LAST you mean the last inserted into temporary table. You should get this with the following /*untested*/ select (though I'm not sure whether this is what you are...

As I understood the various explanations (I really didn't try to understand the SQL itself), the task is to find firms, whose name and address suggest possible duplicity, and create something as...

Just being curious, how many rows will be inserted into this table per day? "Huge" is rather vague...

Anyway, dividing the data into many tables is something I would try to...

That's OK, Jeff, don't mention it :-). No need to talk about it any more, no hard feelings on either side and that's all that's important. Hope you will be...

I don't think there is some basic difference in what you say and what the other half of the statement says. "SQL Server redistributes the data when it creates the...

There are several things that can affect results of a query... ANSI NULLS ON/OFF, language, date format, case sensitivity. Probably some more that I don't remember at the moment -...

I'm sorry if my comment was offending or uncalled for, and I apologize for it. It was meant more like "I feel with you and I wouldn't want to be...

Uhhh... that's really something. Any other restrictions, like for example that you may not use the word "UPDATE" in your SQL?

I can only...

Hi Brian,

You're welcome, I think we understood each other perfectly. If you use the line number, no problem (you even don't have to include product to have a unique combination)...

Hello,

if I only take into account what you posted about the structure of tables, then the mentioned 3 columns can NOT be used as a unique key (or unique index)....

LOL... actually there are no questions in the original post, at least from the point of view that there are no question marks :-). The phrasing suggests that the poster...

Vinny,

unfortunately that is misunderstanding of the term "covered". What the BOL attempts to say in this part is, that if ALL columns specified in the query (from the table to which...