sorry. sql statements for creating table and records are in attached file because they seemed too long to me. the sample data in post actually is not data. I used...

no my friend, because transactions, transaction fees and commissions came from one table, others come from different tables. lets say, transaction's ID is...

I was digging sql2012 sequence feature, looks like don't need to worry about deadlocks nor increments any more but I couldn't find one thing:

where does sql2012 stores sequences. it seems...

I'll give a try to these solutions tonight. by the way, sql version is 2012 and that's not gonna change. only upgrades are posibble.

dear lnardozi 61862,

problem is, I'm not generating invoices. my customers are generating their own invoices for their own customers using my web application. Say, customer A starts operation and generated...

I have customer database. and transactions database. each transaction gets an Id number. okay. 2 different customers made 2 transactions. here's teh trasactions table:

ID CustomerNumber

1...

hmmm, begin/commit transaction looks like did the trick.

begin transaction

declare @no int

exec CreateInvoiceNumber @no output

select @no

insert into test (no) VALUES( @no)

commit transaction

1.000.000 transactions, 200 threds, no duplicates.

thanks... that was educational conversation.

wrong post.

first answer is yes, if I have 10 customers, I need 10 set of invoice numbers.

the transaction I use is:

declare @no int

exec CreateInvoiceNumber @no output

select @no

insert into test (no)...

then if I have 10 customers, I have to have 10 invoice number tables for each of them to keep different invoice numbers for different customers right ?

as I understood...

here's the question: (as I don't know sp's very well, or lest's say I have trust issues against sql server-yet)

is there any chance of 2 insert statements getting same number...

actually null values not my concern (all values are zero or something) but I want to learn howto use isnull function in this kind of function as it will present...

wow, that was cool.... thank you with respect 🙂

here's table definition

CREATE TABLE [dbo].[ExRates](

[ID] [int] IDENTITY(1,1) NOT NULL,

[ratedate] [date] NULL,

[USD] [float] NULL,

[EURO] [float] NULL

) ON [PRIMARY]

GO

insert into ExRates (ratedate, USD,EURO) values ('01-01-2012', 2.1 , 1.8)

insert into ExRates (ratedate, USD,EURO)...

Sure I need it. at he moment I have sql2008r2 side by side with msde. I need to upgrade it. I need to obtain compatibility between web server database, client...