actullay i am fresh in this field so its ok(LATE HALFDAY). i have to learn more from the internet and the forum like sql server central

yes your query is giving...

i do like this

when convert(varchar(10),t.[Timein],108) >= convert(varchar(10),t4.ltime,108) and

spendtime is not null then 'LATE '

else '' end

+ case when (t4.minute- Time_Minutes) >= 120 then + 'HALF DAY'

else...

Thanks i get it

i use this

when convert(varchar(10),t.[Timein],108) >= convert(varchar(10),t4.ltime,108) and spendtime is not null then 'LATE -'

else '' end

+ case when (t4.minute- Time_Minutes) >= 120 then +...

Thanks for the help

yes this is what i want Thanks

but it gives me like this

Remarks

LateHALFDAY

i want this

late / halfday

when only halfday remarks show this Halfday

and when late and halfday remark show...

how i can create a trigger

i am making attendance project for a factory.employee come in factory time in and time out. on sunday employee have off day and some time employee get absent in my...

sir please implemenet on this query

select

[date],

min([Timein]) as First_Record,

sum(DATEDIFF(minute, [Timein], [Timeout])) as Time_Minutes

into #temp1 from Atend

where eid = 26446

group by [date]

GO

select

t.[date],

t.eid,

t.[Timein] as timein,

t.[Timeout] as timeout,

CONVERT(VARCHAR(8), DATEADD(minute, Time_Minutes, 0), 108) AS SpendTime,

case...

This is my calendar data structure

CREATE TABLE [dbo].[Calendar]

(

[Date] [datetime] NULL

)

i insert all 2013 months dates in this table

i want to show offday dates in database like this

date----------------------------eid----shift--------timein---------------------timeout--

2013-05-04 00:00:00.000--17031----G----2013-06-13 09:15:00.000-----2013-06-13 15:23:00.000

2013-05-04...

sir i dont know how its happen becouse i create only one post

your idea is working thanks sir

Sir my first problem about ABS function is solve

sir i change query u can see in bold fonts

but its give me error

Msg 156, Level 15, State 1, Line...

this is my select query

select

CalDate,

Timein,

Timeout ,

CONVERT(varchar(8),DATEADD(ss,DATEDIFF(ss,[Timein],[Timeout]),0),108) AS SpendTime_runtime,

CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) / 60 as varchar ) + ':' +-- Hours ( + ':' separator...

sir this query give me first time in and last time out

SELECT a.eid, a.date, d.InTime, e.OutTime

FROM

(SELECT DISTINCT eid, date FROM atend) a

OUTER APPLY (SELECT b.eid, b.Date, MIN(b.Time) InTime...