Got to know that by default it takes the length as 1 if the size is not declared. Thank you....

However, I still did not get the difference between length...

In the above SP the following statement is found to be time consuming.... i can say it is taking 17 ms everytime it is being executed...

Select @YTDParamValue=isnull(cast(Sum(cast(Corp_Conv_Value as decimal(25,3)))...

the code the the SP usp_Ehs_Evaluate_Formula_WithYTD is as follows:

ALTER Procedure [dbo].[usp_Ehs_Evaluate_Formula_WithYTD]

(

@Formula Varchar(2000),

@Period Varchar(500),

@YTDPeriod Varchar(500),

@LocId Varchar(10),

@LevId int,

@val Varchar(2000) Output,

@YTDVal Varchar(2000)...

As Rajesh suggested me I have tried by removing the insert statement in the while loop and using update statement instead of that...... but it is taking more time than...

yes..... surely..... but i didnt do that because the SP is quite big 🙂

ALTER PROCEDURE [dbo].[usp_FormulaBuilder_Levels] (@Month int, @year int) AS

SET NOCOUNT on

declare @MonthStr table(id int,mnt...