ok thanks.

I will add try catch and extend the sqltimeout from the client.

Regards

yes I stand corrected not insert and update it is the update that failes.

exec ReviseRequest_sp @Requestno,@UserId,'47'

in the procedure above a straight forward one fails becuase of hanging transaction on the...

yes but what is your suggestion on my first scenario?

How can I handle wherein when one insert fails or select statement fails due to server slow

the rest of the SP will fails.

Or can I increase the timeout expired...

Thanks for the infos.

My insert and update is a common transaction every seconds considering the number of users I have.

The application is a tracking system where approval and confirmation is...

No Triggers.

But I have a lot of Select where it exists on many different reports.

What I did for now is to add from my select statement on all reports

"WITH...

Perfect..:-)

But I just received minor changes from our requester that there could be other codes in the future aside from 1 and 0, it will increased as the number of...

Thanks I updated my post. 🙂

Thank you, but I've gone through that site and what I need is an extra 3-4 columns in the matrix and 2-3 rows. I have special calculation requirements in the...

Hi,

I believe the problem is in the program itself, try to put some trap or validation before insert.

Allow me to ask further with Identity column.

Is Identity column the same as...

Thanks.