Set default time in SQL Server, using Stored procedure - Stored Procedures, Triggers, & Functions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » Stored Procedures, Triggers, & Functions » Set default time in SQL Server, using Stored procedure

Set default time in SQL Server, using Stored procedure

Options

Previous Topic · Next Topic

ndindi22

Posted: Tuesday, December 11, 2007 12:49:34 AM

Rank: Newbie

Joined: 11/5/2007
Posts: 2
Points: 6
Location: South Africa

[?]Hi guys

I'm writing a Stored Procedure, on SQL Server 2005. I need to set a default time for the clock system, The clock in/out system works like this: When you clock in = 0, Clock Out = 1. So other employees they forget to clock out, we want to set a default time that when the employee didn't clock out then clock out time is 4:00PM.

I've been struggling I don't know how to tackle it.
Please help.

Ndi

Scott Whigham

Posted: Wednesday, December 19, 2007 1:25:10 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Hi there -

Sorry but I seem to have missed this when you first posted it Frown

Have you resolved this? Without more information, I'm not sure how I could help you. What if you set the default time at 4:00PM but the person clocked in at 3:59PM? or 4:01PM? It would need to be a moving value, I would guess - something like "8 hours from the clock in, if you haven't clocked out for the day, you will be automatically clocked out"

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.