General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Hi Michael,
The SQL database is on a remote server and the offices are located in different locations and they use the same SQL database on the remote server. The shared Office Table has a row for each office with a field for the last transaction Id which will be incremented for each office transactions.
Thanks!!!
Roland
===========================================================================
>Can you provide more information regarding your application? Will all offices be using the same database or will each have their own and then replicate around?
>
>If everyone is using the same database, I'd use an IDENTITY value and include some kind of SiteID as another column in each row.
>
>-Mike
>
>>Hi Michael,
>>
>>I don't think that would ever happen with these offices since they have only had 27,000 transactions over the last ten years.
>>
>>You are right; why put a range limitation.
>>
>>But getting back to the question. What would be the proper way and coding to acccomplish this routine?
>>
>>Thanks!!!
>>Roland
>>
>>===========================================================================
>>>>I need to generate and retreive an unique Transaction_id (int field) for different offices; each office would start off with say 1000000001 for Office One and Office Two would start off with 2000000001; etc. The field would be in the Office Table, one row for each office.
>>>
>>>And what would you do when an office has used up all of the keys within it's range?
>>>
>>>-Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only