Loading

How to generate serial no in sql

Anjali Nawale

hi,....

how to generate serial no starting from 1 for each month chnage or each finacial year change means year no change when yr chnage as (1-4-17 to 31-3-18) in sql or c#

plz ans....

1 Reply

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

Tapan Patel9y ago
1. CREATE TABLE #test(Dt DATE)
2. INSERT INTO #test
3. SELECT '1 - 1 -2018' UNION
4. SELECT '2 - 1 -2018' UNION
5. SELECT '3 - 1 -2018' UNION
6. SELECT '4 - 1 -2017' UNION
7. SELECT '5 - 1 -2017' UNION
8. SELECT '6 - 1 -2017' UNION
9. SELECT '7 - 1 -2017' UNION
10. SELECT '8 - 1 -2017' UNION
11. SELECT '9 - 1 -2017' UNION
12. SELECT '10 - 1 -2017' UNION
13. SELECT '11 - 1 -2017' UNION
14. SELECT '12 - 1 -2017'
16. SELECT Dt,CASE WHEN MONTH(Dt)>3 THEN MONTH(Dt)-3
17. ELSE MONTH(Dt)+(3*3) END [Series]
18. FROM #test
19. ORDER BY Dt Desc
Please mark it as answer if addresses the issue.