حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Each year new id

RPA

RPA

SOLVED CLOSED ACTIVE ANSWERED
User: RPA
Posted: on Apr 27, 2016 02:31 AM
Forum: SQL Server
Answer: 1
Views: 2869

Hi! I have RegisterTable.

Id	Name	Date
1	Rustam	22.12.2016
2	Sadriddin	25.12.2016
3	Firuz	31.12.2016
1	Asror	01.01.2017
2	Nurullo	03.01.2017
3	Karomatullo	05.12.2017

I want each year id began from one. For example I show table in top.

Download FREE API for Word, Excel and PDF in ASP.Net

RPA

RPA

0 2

Reply
User: RPA
Replied: on Apr 27, 2016 02:40 AM
Report

Id begin from 01.01.2016 till 31.12.2016 when each year new id. When begin 01.01.2017 then id began automatically from 1. Output:

Id	Name	Date
1	Rustam	22.12.2016
2	Sadriddin	25.12.2016
3	Firuz	31.12.2016
1	Asror	01.01.2017
2	Nurullo	03.01.2017
3	Karomatullo	05.12.2017

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.

18.222.231.86