Hello everyone, I have a query that counts the total inserted rows in the SQL server. I added 1 to get the new row that should be inserted. See my query below:
- SELECT COUNT(CustomerID) + 1
- FROM fmCustomer
- WHERE year(getLogs) = YEAR(GETDATE())
But, here is the weird thing that always happens:
As you can see, it jumps from 21-00251 to 21-00253. Any suggestions on how can I count total rows + 1? Thanks in advance.