Yes max(id) + 1 is not the best way to go. I would prefer identity columns to this approach.

ta.bu.shi.da.yu (11/11/2008)

---

Chirag (11/10/2008)

---

You do not store either credit or debit values as negative becoz u need to take these values and show them in various reports .This would need multiplying...

You will have to re-create all your jobs, maintenance plans etc.

If you have a clustered index on the table data will be ordered according to the clustered index.

MS should have included Merge also.

Hi

As pointed out ...did u add serial column your non cl index and check?

Grant Fritchey (11/10/2008)

---

Not unless I've missed it to. If the value of a number is -3, it's -3, not 3 with some negative sign kept elsewhere that may or may...

Identity values are "skipped/missed" when there is an error in your insert statement. Even though the insert statement fails the identity value gets used.

Mostly this should be a permissions issue.

You are right abt time saving. If you are doing it in this manner make sure that your data does not break PrimaryKey or Clustered indexes.

You could script the...

I think doing the validation in the trigger and returning an error will cause the whole bulkinsert to fail. If this is the behaviour you want then its fine.

Any chance...

No pivot cant be used in sql 2000....

i think you should look into pivot operator.

Hi

Performance will mostly depend on the number of rows you are going to update rather than the exists clause.

So if you want to update only if the record count is...

yes you can. if record count is only criteria then this will work.

Update table1 set col1 = value

where exists (select * From table2)