By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,689 Members | 1,915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,689 IT Pros & Developers. It's quick & easy.

Duplicate sales invoice numbers

P: 1
I have multiple user environment and want to obtain uniq sales invoice no for each user
I run update query
Expand|Select|Wrap|Line Numbers
  1. ALTER PROCEDURE [dbo].[A_refupdate]
  2.     -- Add the parameters for the stored procedure here
  3.     @gid varchar(5)
  4. AS
  5. UPDATE [SSENTP2].[dbo].[TB_KEY_CONTROL]
  6.     WITH (ROWLOCK) SET COUNTERS =COUNTERS+.000001
  7.  
  8. UPDATE [SSENTP2].[dbo].[TB_KEY_CONTROL]
  9.    WITH (ROWLOCK) SET    voucher=INITIALS+SUBSTRing(STR(COUNTERS,8,7),3,7) 
  10.      WHERE KEY_ID=@gid
It is not allotting unique invoice number to the users

i will be very thank full if any one guide me to right way
Apr 14 '14 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,430
We can't help unless we know the table definitions.
Apr 14 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.