I try to explane
I have this
- INSERT INTO dbo.nalog_knjizenje_stavke (redni_broj, konto, naziv_konta, duguje, potrazuje, id_fakture)
- select ROW_NUMBER() OVER (ORDER BY redni_broj), konto, naziv_konta, '0.00','0.00', (select MAX(id) from dbo.nalog_knjizenje_lista) as id_fakture
- from dbo.kontni_plan
- where broj_dokumenta = 2301
That is ok.
Now question, ho to put inside differtent value in last two column when are different column konto.
Need help and need result to be example
Thank you
Periyasamy VellingirisamyPosted Apr 10, 2020, 8:04 AM