Oops I got my environments mixed up. I am actually working in Visual Studio .Net and my code is C#. Your code is the equivalent of my code in C#....

Actually none of this is documented. They are unable to give me documentation at all on the processes other then high level business processes that were created years ago. They...

That is the rosey side of it. But what do you do when their business requirements contradic themselves? When they refuse to see that they do and the next week...

Opc.three and Craig thank you very much for you advice and efforts in sharing your knowledge. I do very much value your replies. Thanks.

opc.three (4/4/2012)

---

The point Craig and I are trying to drive home is: unless you have a requirement that says that a sequence of IDs cannot have any gaps in...

opc.three (4/4/2012)

---

The point Craig and I are trying to drive home is: unless you have a requirement that says that a sequence of IDs cannot have any gaps in...

opc.three (4/4/2012)

---

The point Craig and I are trying to drive home is: unless you have a requirement that says that a sequence of IDs cannot have any gaps in...

opc.three (4/4/2012)

---

The point Craig and I are trying to drive home is: unless you have a requirement that says that a sequence of IDs cannot have any gaps in...

Thanks Lynn for the code. Yes, I think you paraphrased it pretty well. The moving around of the file is the file and it's data being processed and moved to...

The ID column will never be changed. It is a chronological record of a file moving from one place to another. The only purpose outside that for the table is...

Preferred in your mind but in your mind you don't know what my table structure and business requirements are.

Thanks opc.three. To answer your question, it isn't an identity column, it is an ID that is meant to track a file through-out it's journey on the network. So there...

This seems to work and has the added benefit of incrementing the ID by one which will work nicely with my next insert statement:

CREATE PROCEDURE [dbo].[spGenerateID] ...

Just to be closure to my post. I decided to copy the file to a staging folder and do the hash on that file. Seems to work really well.

TeraByteMe (3/28/2012)

---

opc.three:...

opc.three: Once again you surpass the brilliant. That is a great suggestion. I love the way you think!