Lynn,

Actually, at this stage I am just trying to create the trigger so I will not be received access denied.

However, I already check the sp in new windows and...

Still the same error. I took out all the lookup statement (select * from watever wehre id-id) and still the same.

------------------------*/

Msg 156, Level 15, State 1, Procedure it_myTrigger, Line 46

Incorrect...

I am getting these errors...

Msg 156, Level 15, State 1, Procedure it_myTrigger, Line 39

Incorrect syntax near the keyword 'where'.

Msg 156, Level 15, State 1, Procedure it_myTrigger, Line 41

Incorrect syntax near...

1. I moved the roll back statement right after begin catch line but before insert into log

2. Thanks for the quick reply. Do you think I am "FROM...

I created 2 buttons (punch in and punch out) and then everything else was easy and less complex. Pls mark this post as Resolved.

The new sql statement works and gives me records. However, I do not need all the columns. I need to add a column cStatus to display In/Out based on the...

Lowell,

You are right on target. Also, I wanted to thank you for answering me and helping me with the code. truly appreciated. I am getting following error when I execute...

i am so sorry for multiple posts. i wasnt sure where to put it. again very sorry.

and

thanks all for your contribution. I will sure to try all of them.

thanks

This seems to be doing but need more testing.

SELECT cd.emp_id, MIN(CASE WHEN (cd.time_out IS NULL) THEN 'in' ELSE 'out' END) AS cStatus

FROM ...

Hello Wayne,

YOU ARE TOOOOOOO GOOD AND GENEROUS OF YOUR TIME. I HAVE NO IDEA HOW I AM GOING TO THANK YOU.

It worked like charm. You could off spend more time...

Wayne,

Sorry. Didnt mean to take you away from your family time. NO doubt family is first. That is why I am going to do this in c# .net cause of...

That's funny. LOL.

How come people have all the time to comment on how to post?

Who really cares as long as it's not all that offensive?

I need some solution,...

wayne, where r u? I attached both sql to create tables and data. I can create exact logic in .net but I like to do it in sql server as...

I have attached sql of the tables with data. Please let me know. Thanks for all the help. I truely appreciate it.

Here is my goal.

1. Determine where I need to...