Hey, What's the size data inserted into the table? I recommend to use create clustered index for better performance. Also create index on the table after insertion of records.

See if you can change the dataType from char to varchar and update the coulmn by trimming it.

That would be a realistic way 🙂 U needn't worry about restarting the jobs whenever you are back or needn't put an reminder for every holiday.

Please share the code snippet of trigger and procedure

Whats the o/p of below query at first place?

select CountyFIPS

from ##test_backfillGeo

where CountyFIPS not like ''

Thanks to all. Since we have trace enabled for our databased. I used them to extract required info.

Let me try using profiler. Do we have any other solution than profiler?

You are correct Jim. I need to capture the rows affected for each query fired along with it's counter part. At a time multiple queries can be fired together.

If i use @@rowcount, then i will get for last query but not set of qureies fired 🙁

Thanks for reply. But how can aduit the qureies fired by end users against the rows affected?

Thanks dude. It worked for me

In the following query I need to make it work without WHILE loop.

Create Table Job (JobID int identity, Role char(10), Location char(50))

Create Table Employee (EmpID int identity, EmpName char(50), Role...