How i identity column using datenow in sql

Question

1.00/5 (1 vote)

See more:

i crate table like this :-
id , name , Counter , date
--- ---- ------ -----
11 , ma , 1 , 15-2-2016
21 , kk , 2 , 15-2-2016
30 , dd , 3 , 15-2-2016
10 , ss , 1 , 16-2-2016
25 , dd , 2 , 16-2-2016

i want identity column's counter where date

What I have tried:

and when i insert become counter +1

Posted 16-Feb-16 0:22am

Member 12244977

Add a Solution

Comments

[no name] 16-Feb-16 6:52am

Records are already there in your table and you want to update Counter value or you want to insert the records like above?

Member 12244977 16-Feb-16 6:55am

insert when i insert new row the counter column make +1 but when i change date ,column counter count from first

ZurdoDev 16-Feb-16 8:22am

1. Reply to the comment so that the user is notified.
2. This is not clear. But all you probably have to do is use a case statement but I can't help because I cannot understand you.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Corporal Agarn · Accepted Answer · 2016-02-16T02:33:00

Solution 1

Try ROW_NUMBER() OVER (PARTITION BY [DATE] ORDER BY [DATE]) AS Counter

Posted 16-Feb-16 2:33am

Corporal Agarn

v2

Comments

Member 12244977 17-Feb-16 4:39am

its work thank you