Hi,

I have this solution but mainly I want to know whatz the reason????

Why it below block of code gives error.

Declare @user varchar(200)

set @user = 'mymachine\vishal'

GRANT  EXECUTE  ON mytest_sp TO @user

GO

Hi,

Thankz mike for you reply.... Please send me utility.... It will really help me....

Please send me at vishu_prajapati@yahoo.co.in

Thanking

Hi,

Thankz for your reply.

Global #table will not work as it in Client-Sever Architecture and at time there are 4-5 users logged in accessing may be same SP.

Please help

Hi,

Please help on it......

Are you finding it difficult to get the solution or you not getting what I want......

Hi,

Thankz for your reply. It really added some idea in reaching to a solution. But still actual problem is not addressed.

Let me explain you with example:

At fornt end I have...

Hi,

Thankz for your reply. Same we have also thought of but where to create the # table.

If in SP I have to create then any how the problem remains...

Hi,

ALL PC in a company are of NTFS file system.....

Please help..... We are not able troubleshoot.....

Hi,

I have set this at Infinite ( connection timeout = 0)

And that too at both end. At Sql Server also and in ADO connection also. BUT 🙁

HI,

Sorry to bother you....

But it does not take any parameter. I just call the SP and it gives me the result for 12 months. The same SP when I...

Hi,

Thanks for reply.....

I told in my original post that it works locally very fine. Also when the SP is run through the Query Analyser of client server, there also...

Hi,

Thanks for you reply.....

But this does not help out as we are making use of client side cursor only......

Please help

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...

Hi,

Thankz dear. Your help really worked out. I have never tried CROSS JOIN this way.

Hi,

Vishal again...

Thankz to all for your reply.

But the solution which you have given is specific to the arithmetic error. I want to have the general solution. If any type...

HI,

THANKZ A LOT to all of you. I got the solution. It really helped me out. I was not knowing about sp_executesql SP as I was new to Sql Server....