maybe I am not explaining this correctly.

HaulerID = 2

Asset ...

thank you very much. I realized using SQL managment studio to generate these permit numbers is a lame idea. They can just use Microsoft Access form to generate these ...

Sean Lange (11/28/2012)

---

sasansamani (11/28/2012)

---

Our department wants to automatically generate permit numbers for our customers when they apply for a license.They want something similar to a key generator. Yes SQL Server...

Our department wants to automatically generate permit numbers for our customers when they apply for a license.They want something similar to a key generator. Yes SQL Server is my only...

Let me explain what exactly we are trying to do.

Waste Hauler Unique Number Example: 00000-V/C 0000- AT- YR

Requirements:

Hauler # = 00000 (permanent)- there may be 1000 hauler companies

Asset =...

thank you for your reply.

Can I use the Identity Property in SQL express 2008?

I guess I need to know where I need to start from.