Use This:

-- PARAMETERS COME FROM USER INPUT AND CAN INCREASE BASED ON REPORTING

DECLARE @TSQL1 NVARCHAR(4000)

DECLARE @TSQLAll NVARCHAR(4000)

SET @TSQL1 = '

DECLARE @Date1 DATETIME

SET @Date1 = ''1991/06/01''

DECLARE @Date2 DATETIME

SET @Date2 =...

Generally reboot production server at weekends or after any new patch.

You can use OutPut variable in such cases...

eg.

Declare @outputvar1 as Int

Exec usp_yoursp @pr1,@pr2,@outputvar1 Output

Hi,

You mean,

At Table1

Insert into Table1(empID,ErrorCount,ErrorDate) Values(1,5,'27-05-2009')

At Table2

5 new rows for empID 1

eg.

Insert Into Table2(ErrorID,ErrorDate,IsError,EmpID,Notes) Values

...

Use Batch Update if you are updating/inserting records from ASP.Net.