How to Insert the record only once in the current Month?

Veeramanikandan Dhanabalan

how to insert the record into the database by date/time .The same id will not inserted another time until a month over..

For example, take salary detail if we inserted employee by the employee ID with date/time in the database about the salary detail ..the same person Id could not inserted again until the one month....If one month over we can insert the same faculty details again...

Thanks in Advance

4 Replies

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

Sam Hobbs15y ago
I am not as familiar with SQL Server as others here are, but I assume you can have a field that is a combination of year and month and allow only one occruance of a value for each employee. That is very basic for most databases. The month field can be the muber of months since a specific month. Let's say you the start month is January of 2000. Then January of 2001 would be 12. December of 2010 I think would be month 119. Would that work?
Vijay Yadav15y ago
In this, you can change the date format accordingly. Hope this will help you!
Vijay Yadav15y ago
Hi,

I have done the same thing in my project.

Like this,

int i = 0;
int x = DateTime.Now.Month;
int y = DateTime.Now.Year;
if (x == 12)
{
i = 1;
y = y + 1;
}
else
i = DateTime.Now.Month + 1;
int m=DateTime.DaysInMonth(y,i);
string s = i + "/01/" + y + " 12:00:00 PM";
string ss=i+"/"+m+"/"+y +" 11:59:59 PM"; // the date format is in yyyy/MM/dd hh:mm:ss
then your select query
for example: select Emp_Name from table where date between 's' and 'ss'
Dorababu Meka15y ago
Get the date of the employee id while you are inserting and compare the month of the date belongs to current month or not if current month then don't insert else insert the record.