Loading

Counter in SQL from C#

Goran Bibic

6y830SQL

I try this

declare @maxNo integer = 0 select @maxNo = isnull(max(redni_broj), 0) from [dbo].[prenosnica_roba] WHERE id_fakture=3;Set @maxNo=@maxNo+1;

I have reslult
1
1
1
..

Need to have
1
2
3
..

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
It is not clear to me what you are asking. Can you give example data and expected output?
0
Goran Bibic6y ago
pritaeas

Code is ok

But i Have multiple value and result is
redni_broj                   Item             Price
21 Item1           68.22
21               Item2           53.55
0
Guest User6y ago
1. INSERT into dbo.prenosnica_roba (redni_broj)
2. SELECT (
3. select 1 + isnull(max(redni_broj), 0) from [dbo].[prenosnica_roba] WHERE id_fakture=3)
4. FROM dbo.mp_racun_roba
This sub-select should work
+1

Result is

2

..

0

Shouldn't this work?

declare @maxNo integer = 0;
select @maxNo = isnull(max(redni_broj), 0) from [dbo].[prenosnica_roba] WHERE id_fakture=3;
INSERT into dbo.prenosnica_roba (redni_broj)
SELECT @maxNo=@maxNo+1
FROM dbo.mp_racun_roba

Otherwise you can use a sub-select

+1