>I have a question:  Why the dbo. ?<

the object owner (here dbo. = DataBaseOwner) is always an  integral part of naming in SQL-Server. This is true for all objects (tables, procedures...

>But your observations are assumptions also<

True - I always assume the worst. Advisable  practice, as far as reality is concerned 

Do we start a new thread on...

% (Modulo)

Provides the remainder of one number divided by another.

Syntax

dividend % divisor

Why not use, what's already there? Too straightforward, I suppose ...

There's a new feature in SQL-2005: DELETE TOP (n). That's for you. I hate to manipulate data this way. This seems to me a...

Sum(CASE tblDataTableNew.CustType='Wachovia' THEN ImageItems ELSE 0 END) AS WviaImage

As for performance and large amounts of data it might even prove useful to first drop the index and recreate it afterwards, but that depends on the data ...

Apart from the above mentioned problem, you'll always update the values, whether they've changed or not. This should not happen either. Think of this in terms of performance.

There's still another...

Again, David. One thing in advance: I think we all know Celko's nice SQL puzzles, here for example calculating running sums or ordering records using plain SQL.

I'm a supporter of plain...

I'm pretty sure, I know and I knew, what you mean, but let me state again, what I already wrote in a prior message: 

>it is still NOT clear, whether...

Just have a look at what will happen when you restart with this situation being the starting point: (again 350 to schedule)

1, 2006/3/1, 100.000, MATERIAL1,50

2, 2006/3/3, 200.000, MATERIAL1,0

3, 2006/3/3, 150.000,...

True, but the old standard will be discontinued.

>Ultimately the engine will translte the first into the second.

If the meaning is clear, yes. But this is not always the case.

Ok,...

I'm really not trying to define YOUR VERY OWN goals, but be very, very careful with the second solution Drop me a message,...

This means, you didn't understand the goal either

why would you do so?

I suggest you use first syntax if you're british, and second, if you're american. If you're neither, simply switch from time to time 

possible solutions:

a) use second...