Thank You Guys for the examples

I need to look at tables, stored procedures (declarations) and views

There no need to look at dynamic SQL because it is not being used....

Thanks

What I forgot to tel is that on the other server, the identity increments as it should....

And stiil if it is an identity it should count up, not stay...

Hello,

the table is no longer in in replication. so I'm wondering

1 - why is it always the same number

2 - Were is the value coming from, the starting...

Ok gave it a try. Think it should look like this....

Wat do you think.. Thanks

INSERT INTO INFO_EXPORT_MOVEMENT(

                     ItemCode,

                     Quantity,

                     MovementType,

                     LocationFrom,

                     LocationTo,

                     RefEbly,

                     RefSupplier)

SELECT

               ITEM_CODE,

               UNITS * SUB_UNITS,...

Hello adict,

Part of your example I understand, about the case statement for the'new value', But how do I get the 'Delete' or Previous value into the picture?

I have no idea....

Jezus Paul,

Right from the first time. And it's so simple.

Many thanks Paul

Hello Andy,

No we are running SQL 2000 SP2 with the hotfix.

quote:

---

SQL7?

Andy

http://qa.sqlservercentral.com/columnists/awarren/

---

I'm happy to say that NLB does the trick. The problem was a utility from campaq 'teaming software' which does a balance load on the two nicks. We thought we...

THANKS for the info