Counter in SQL from C#

Question

I try this

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

I have reslult
1
1
1
..

Need to have
1
2
3
..