That looks like it will do what you want. I don't know that I would say it is "right". 😉

You might try to suggest to the powers that be that...

No offense but this code is a disaster. You have 2 cursors and the declarations are completely different, the check for fetch_status are overly complicated and not documented. Do you...

I am going to guess that you didn't read that article. It certainly is somewhat of a help to see all of...

Yes, you can't write...

Talk about sparse details. It would be helpful if in the future you could provide more details. At the very least declare the variables.

Once I declared the variables so I...

poratips (1/22/2013)

---

I do completely agree with you but i have just started and suggested to create DEV but company is small and i don't when they will do?

My procedure modification...

poratips (1/22/2013)

---

Thanks Sean once again for your resposnse.

I need for 45 minutes check but i can also set up as 30 minutes.

I was trying to implement in one shot like...

Just for fun here is another way.

select replicate(' ', 81)

p.ramchander (1/22/2013)

---

I am working on a clock in and clock out system. I have one table with Employee id, punchTime, punchType.

test data:

ClockIDEmployeeIDpunchTimepunchType

87692013-01-22 14:26:35.5901

97692013-01-22 14:46:59.3630

105092013-01-22 14:49:17.2601

115092013-01-22 15:13:10.7700

where punchtype '0' for out...

The main you have not yet received a response is because your question has no details. We need ddl and sample data at a bare minimum. Please read the article...

Your question is extremely vague but I think you want something like this.

Add this above your cte.

declare @QuestionCount int

select @QuestionCount = count(*) from @Question where Record = @Record

Now you have...

davdam8 (1/22/2013)

---

SQL Newbie here!

Sorry, don't have any data on the table yet, this is a projection of what it will contain.

I apreciate all the help I can get for this...

That looks pretty close. You said that you want to stop if the process runs for 45 minutes but your check is < 30. You can change that to 45...

poratips (1/21/2013)

---

Thanks.

We don't need to stop at certain time clock, we need to quit the job (stored procedure) in it's running more than 45 minutes as currently it's runnning from...

If you just want to stop processing at a certain point in time add a start time at the top of your code and check it on each pass through...