Hi,

If i use ur Query I am getting the result like 666768. But I need to pass the value as 66,67,68

That will return 118 rows here is the record for that

IDTYPEGROUPIDSETUPIDLEVELVALUEIDMETRICSIDMETRICSNAMEDIMENSIONIDDIMENSIONVALUEIDMETRICSVALUEGOALSETUPUOMUOMPERFORMANCETOOLTIPTARGETPDIDPHASEIDSORTORDER

11116313145143% Core Effort1143NULL1004NULLNULL3100NULLNULL1

21216313145144Application Defect Leakage %114415.751004NULLNULL2100NULLNULL1

31216313145145Application Defect Leakage by Severity S1%11454.111004NULLNULL2100NULLNULL1

41216313145145System Test Execution429630701004NULLNULL2100NULL2963071

51216313145145System Integration Test Execution429630801004NULLNULL2100NULL2963081

61216313145145Regression Test Suite Execution429630901004NULLNULL2100NULL2963091

71216313145146Application Defect...

Currently my updte statement is updating only for the first metric ID in the lean table

THIS is the lean TEMP table

DECLARE @LEANTEMP TABLE

(

ID INT IDENTITY(1,1),

TYPE INT,

GROUPID BIGINT, ...

Hi I know what is happening, but i need to update fields in MEAS table based on Metric ID, the update statement which i have provided is not updating correctly,...

Hope this will help you

SElect top 1 ClientUserName from (SELECT top 2 row_number() over(order by counts DESC) as ID

FROM #ProxyLog_count_2

...

I dont think i can do this stuff in a single statement, because i need to find which colouring ID each metrics belongs to based on that only i can...

Yes pass some value for @Date1, it will solve your issue

Hi Dave here is my code for performance

ALTER PROCEDURE [SCHEMAMANLOG].[PROC_TESTING_EFFORTVARIANCEPERFORMANCE]

(

@LEVELVALUEID BIGINT,

@METRICSID INT ,

@METRICSVALUE FLOAT,

@GOAL FLOAT,

@TARGET FLOAT,

@FROMDATE DATE,

@TODATE DATE,

@ProcessDisciplineID INT,

@PHASEID BIGINT

)

AS

BEGIN

DECLARE @COLORIND INT...

Thanks Ravi i have changed the code, I am using while loop now...Hope it will not affect my performance in future 🙂

You need to do like this

INSERT INTO [dbo].[TableName] ( Column1 , Column2 )

SELECT *

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\TableName.xls',

'SELECT * FROM [Sheet1$]')

Here I am taking records from @LEANTEMP table and passing the values to SP to calculate performance for each Metric ID.

Hi Sambireddy,

Anyhow Employee table will be having the EMP ID which is in EMployee _Details table right. If you need the data from Employee_details only means you...

select * from Employee_Details ED inner join EmployeeTable ET

on ET.EmpID=ED.EmpID

Hi Thanks for all of your reply....

Here is my code

--- Cursor To EXECUTE PERFORMANCE SP FOR EACH METRICID

DECLARE @METID INT

DECLARE @METRICVALUE FLOAT

DECLARE @GOAL FLOAT

DECLARE @TARGET FLOAT

DECLARE @PDID BIGINT

DECLARE...