Logic For Extracting data based on latest Entry

Question

0.00/5 (No votes)

See more:

<pre><pre lang="text"><pre lang="text">
Hello every body i need a logic for Extracting the data based on dates.

Employees enter the data every day,we offer allowances with effective dates, my problem is if we set allowance with effective date for eg:01/09/2013 the allowance should be effective from 01/09/2013.if the employee enters 29th or 30th entry the allowance should come from allowance that we updated before 01/09/2013.if employee enters for 01/09/2013 the allowance should be new.How to work out the logic.pls help me.

Posted 26-Aug-13 2:13am

Member 10229493

Add a Solution

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)

Aarti Meswania · Accepted Answer · 2013-08-26T02:19:00

Solution 1

SQL

select  
AllownceID, effectiveDate
from tableAllownce 
where effectiveDate <= @Salarydate 
Order by effectiveDate desc

Happy Coding!
:)

Posted 26-Aug-13 2:19am

Aarti Meswania

Comments

Member 10229493 26-Aug-13 12:20pm

Thanks sir..but it is ok for fewer employees.There is a header table and detail table i am having based on max effective date i created the view that show values from detail and header with effective date.From the front end i just pass the employee code (eg)select * from vallowance where empcode=1234 like that..i extract last entry if say the employee enters upto 26/08/2013 i check it and i sets the next date automatically .how to work out the logic..pls help me