If somebody could help me to solve this problem
I am trying to insert same data from the previews month except Month should be Month+1. And I did it in this way (code down), works perfect. What I want now is when Month > 12 then Month = 1, this mean to start again from the first month (January).
Here is my table with fields..
INSERT INTO myTable ( [Year], field1, field2, field3, field4, Month )
SELECT [@CurrentYear] AS [Year], field1, field2, field3, field4, Month+1