Hi,

Here is the SP ........

ALTER PROC getaverage

AS

SET ANSI_WARNINGS OFF

SET NOCOUNT ON

 CREATE TABLE #tblAverage (

  [ID] int,

  [Month]  varchar(100),

  [Value]  varchar(20))  

 DECLARE @NoofMonth int

 SET  @NoofMonth = 0

WHILE @NoofMonth < 12

BEGIN 

INSERT INTO #tblAverage SELECT DISTINCT TABLE1.ID, 'Month ' + cast(@NoofMonth + 1 as varchar), count(TABLE2.User) FROM TABLE1, TABLE2

WHERE TABLE1.ID = TABLE2.ID AND DATEPART(mm,TABLE1.DT) = @NoofMonth

AND  DATEPART(yy,TABLE1.DT) = '2004'

GROUP BY TABLE1.ID

 SET @NoofMonth = @NoofMonth + 1

END

SELECT * FROM #tblAverage 

DROP TABLE #tblAverage

SET NOCOUNT OFF

SET ANSI_WARNINGS ON

GO

------------------------------------------------

AGAIN SP WORKS FINE Locally in Query Analyser and also AT Client's Server Query Analyser.