TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Akhter HUssain
720
1.3k
102.3k
Display all employee whether their Datetime(A_Date) exit or
Sep 20 2019 12:52 AM
I want to display all employee whether their A_Date exit or not
here is ny data
create
table
#EmpMaster(EnrollNumber
int
, EmpName
varchar
(
max
))
Create
table
#AttendenceLOG (ID
int
,EnrollNumber
int
,A_Date datetime)
insert
into
#EmpMaster
values
(1001,
'
Kashif
'
),(1002,
'Kami'
),(1003,
'
Ali
'
),(1004,
'
Farhan
'
),(1005,
'Akhter'
),(1006,
'Rehan'
),(1006,
'Irfan'
)
insert
into
#AttendenceLOG
values
(1,1001,
'2019-05-28 17:18'
),(2,1002,
'2018-05-28 17:18'
),(3,1003,
'2018-05-28 17:18'
),(4, 1006,
'2018-05-28 17:18'
)
My desire ouput
EnrollNumber
Name
A_Date
1001
Kashif
2019-05-28 17:18
1002
Kami
2018-05-28 17:18
1003
Ali
2018-05-28 17:18
1004
Farhan
1005
Akhter
1006
Irfan
2018-05-28 17:18
i tired below query but result is not coming which i want
SELECT
A.EnrollNumber, E.EmpName
AS
EmployeeName, A.A_Date
FROM
AttendenceLOG
AS
A
left
JOIN
EmpMaster
AS
E
ON
E.EnrollNumber = A.EnrollNumber
Reply
Answers (
1
)
an unhandled Microsoft.net framework exception
unable to perform date validation using jquery