| Eric Stott 2006-04-27, 7:25 am |
| We did something similar, we had a view that would go against the table and
grab the smallest row with the bit as 0 and we would use the database
functoids to do it. Should not be hard as long as you then updated the table
to change the bit to 1 on import (stored procedure I would suggest.
Eric
http://stottcreations.com/blog
"Jason" <Jason@discussions.microsoft.com> wrote in message
news:66E87329-1873-44F4-B69A-0FA92250E91B@microsoft.com...
> My purpose is to generate IDs in the format of:
> Date + Unique Character + Incremented value.
> (ex. 20060420W001, 20060420W002)
> This is a requirement for a client. An import may happen more than once a
> day. Is it possible (on a second import) to look into the database from
> the
> mapper to see what values exist and start the second import after the
> largest
> value that already exists? Thanks.
|