Number of employess may be high, number of columns will exceed the limit . You can take all the employee ids and hardcode otherwise need to use...
Do a batch delete substitiute table and where condition . pk denotes primary key on the table Try on a test table and if found ok , use on...
Time out can occur due to lot of reasons 1. Improper indexes on table 2. Statistics not updated 3. Query is not optimized 4. Insufficient Memory...
exec sp_executesql @SqlString, N'@DbMonthlyname nvarchar(40), @StartDate DATETIME, @Enddate DATETIME', @DbMonthlyname, @StartDate, @Enddate M A...
Following should work Create procedure usp1 as declare @rtnvalue int begin tran exec @rtnvalue = usp2 if rtnvalue <> 0 goto error_rtn...
Let me know threshold value for each counter M A Srinivas
Separate names with a comma.
