1)it is my stored procedure.

2) I  debuged my sp and it stated running properly. and after that it was also running properly with same params.

but after sometimes it showed...

Trying to get different perspectives! May be I am looking at the things might not be the right. Getting awareness from wise people will definitely make me think...

Glad to see I wasn't the only one to think that.  I subscribed to this thread yesterday to see if the other shoe drops.

And, just to be sure, my initial post didn't cite your response.  It was meant more for the op.  I'll explicitly state that next time.

I know there was no mention of a normal time/attendance table.. that's why I'm mentioning it now. 😉  The overall process should keep track of all time by project/rate and...

Heh... Ya think? 😀

Why is there a...

At first blush, it would appear that the memo field of the file has at least one line in the file where the text of the memo is wider than...

I'm kinda curious why anyone thinks that a separate overtime table is needed at all.

As per app team, this query is executed several times and response times are higher (3-5 secs). We checked for blocking scenarios,

waiting for locks, what other things to be...

It's got to have you wondering, no?  Where the line is to be drawn?  How many doublings do we have remaining?  What really changes because I'm...

Ah... never mind... I found the reason for the disparity in the chat...

Looking forward to the meeting.

Thank you for the very kind words but I don't consider myself to be a master of anything.  I get real lucky on some things. 😀

I am a bit confused...

Good lord. 🙁

Could just be a lack of coffee but I have no idea how your combination of Product_ID and Qty would produce the results you posted.

NM.