Interview Question : Select List Of those Employee who comes late Office after Office Timing

Submit Code |

Search Codes |

Code Home |

CREATE TABLE EMPMaster(
[EMP_Name] [varchar](50) NULL,
[InTime] [datetime] NULL
)

Insert INTO EMPMaster Values('AA','2012-07-06 09:33:02.933')
Insert INTO EMPMaster Values('BB','2012-07-06 08:45:02.933')
Insert INTO EMPMaster Values('CC','2012-07-06 10:45:02.933')
Insert INTO EMPMaster Values('DD','2012-07-06 09:33:02.933')
Insert INTO EMPMaster Values('EE','2012-07-06 08:59:02.933')
Insert INTO EMPMaster Values('FF','2012-07-06 10:33:02.933')

Declare @OfficeTime Varchar(10)
Set @OfficeTime='09:00AM'

SELECT * FROM EMPMaster WHERE CONVERT(VARCHAR,GETDATE(),101)=CONVERT(VARCHAR,InTime,101) AND
RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,InTime,100),8)),7) > @OfficeTime

Thanks & Regards ,
Anu Malik

Found interesting? Add this to:

| More | Bookmark It

Responses
Posted by: Jasminej \| Posted on: 7/6/2012 \| Level: Starter \| Status: [Member] \| Points: 10 \| Alert Moderator You can also simple use like... Declare @OfficeTime Varchar(10) Set @OfficeTime='09:00AM' Select * from EMPMaster Where [InTime] > Cast(CONVERT(Varchar(10), GetDate(),121) + ' ' + @OfficeTime as Datetime)
Posted by: Anu.Malik \| Posted on: 7/6/2012 \| Level: Starter \| Status: [Member] \| Points: 10 \| Alert Moderator Yes Nice Thanks & Regards , Anu Malik

>> Write Response - Respond to this post and get points

More codes snippets

Submit Code | More ...

Interview Question : Select List Of those Employee who comes late Office after Office Timing

Responses

More codes snippets