By Using Below the uery vzn

Question

1.00/5 (2 votes)

See more:

SQL

DECLARE @attendance_date datetime
set @attendance_date  = '2014-02-20'

Posted 25-Feb-14 2:32am

Member 10501509

Updated 26-Feb-14 17:14pm

v4

Add a Solution

3 solutions

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)

Kornfeld Eliyahu Peter · Answer 1 · 2014-02-25T02:55:00

Solution 1

http://www.w3schools.com/sql/sql_between.asp[^]

Posted 25-Feb-14 2:55am

Kornfeld Eliyahu Peter

Comments

Member 10501509 25-Feb-14 8:58am

if i use between it will display absentees between the date range

Kornfeld Eliyahu Peter 25-Feb-14 9:16am

It seems I did not understand you well...
Can you show an example of results?

Member 10501509 25-Feb-14 9:20am

excepted output
16 Erappa Amanda 2014-02-20 00:00:00.000
25 Madhusudhan Rollapati 2014-02-21 00:00:00.000
27 Maruthi Krishnappagari 2014-02-22 00:00:00.000

Member 10501509 25-Feb-14 9:22am

see in excepted output each user is absent for particular date that i want to display if i give between date range ,i mean to say date should be loop until the end date .

Kornfeld Eliyahu Peter 25-Feb-14 9:24am

I cant' see why BETWEEN not works for you...

Member 10501509 25-Feb-14 9:26am

i am using different tables one is Employee_Attendance and TM_User that checktime is in Employee_Attendance

_Asif_ · Answer 2 · 2014-02-25T03:13:00

Solution 2

Try this

SQL

select  TM.TM_UserID, TM.FullName, @attendance_date 
from TM_User TM
where TM.is_active=1  and  TM.TM_UserID not in
(SELECT EM2.EmployeeID from Employee_Attendance EM2 
   WHERE EM2.CheckTime BETWEEN '20-02-2014' AND '21-02-2014')

Posted 25-Feb-14 3:13am

_Asif_

Comments

Member 10501509 25-Feb-14 9:15am

even want to display particular absentees date for user also

SDAP_INDIA · Answer 3 · 2014-02-25T06:03:00

Solution 3

Does not seems any problem,
use cast function and convert all dates while using them
it should work;

Posted 25-Feb-14 6:03am

SDAP_INDIA

Comments

Member 10501509 25-Feb-14 23:09pm

Please can you provide a query .

Member 10501509 25-Feb-14 23:14pm

I am unable to do please provide a query to me.