Total number of orders for the next 3 days is 7: 4 + 3 + 0.

Can you explain your logic more precisely?

Ninja's_RGR'us (10/2/2007)

---

Just curious on how you guys proceed...

if for exemple something more major happened and that it takes more than 1 hour to correct the situation, do you re-issue access,...

If

WHERE FieldName > 0

is what you need?

If you cannot change it why are you asking how to change it?

DB developers are not allowed to feel anything.

They must KNOW.

If they don't know they must TEST.

Try both ways and see fir yourself.

Can you prove your point?

Did you ever experience performance losses die to IF UPDATE() check?

Is...

I know.

Don't worry about that.

:smooooth:

Where you've got FLOAT field?

Would not UPDATE() work in INSERT case?

It will work perfectly.

Yes, it will return "TRUE" for every column, but what does it change?

We still have to run the same script...

mrpolecat (10/3/2007)

---

Matt- At one point in time the table allowed for a formatted phone number xxx-xxx-xxxx. It is not used so I think could change it to char(10) or...

RD,

Why you need to mention ORDHEADER twice?

inserted is ORDHEADER, right?

update ORDLINE

set ORDLINE.qty_to_ship = inserted.qty_ordered,

ORDLINE.udf_4 = '*'

from inserted

WHERE inserted.order_no = ordline.order_no and inserted.line_no = ordline.line_no

AND (inserted.status < '4') AND (inserted.type...

Not quite true.

I would say absolutely false.

:Whistling:

Matt,

partitioning won't work.

He supposes to delete all records not in upload.

On 1st 10% of upload he'll delete about 90% of existing data - oooops.

The point is not to do update...

You need to create function from your inner query and use it like this:

SELECT ..., dbo.ConcatCodes(key, 30)

FROM ParentTable

mrpolecat,

1st, if you stick to PK then create it before uploading data.

In this case it will insert directly into index, no wasting time for reordering already loaded rows.

And make sure...