sir,that was a dummy table for this cae.I dont know what is the reason,is it becuase there are 1000 rows?the output of the cursor shows as I mentioned as 121.1...

hello sir,there seems to be one issue with this.the quantity column in the table ReorderS is a number.Using this way I find that value is in some case getting rounded...

thank you sir.it worked

Hi Sir,

That works as far as the output is concerned but I need to use dynamic sql since i am using this to execute a statement to update in the...

That worked.Thanks,Yes there is only 1 row for a given date.

No sir,It gives error.

the db is 2005 but we most of the things are still done as 2000.

Isnt there another way?-Thanks

Hi tomm,

thanks for the help but one question,@InsuranceCompany is and Integer so does it have to be modified?

looks like data type conversion error but when i did as Gila told I get a new error as shown below.

Can some one help me with this please.

Server Error in...

I am running from an application which runs this s.proc to fetch the queries.to be honest this was done by somelse who in not with us now.I just need to...

Server Error in '/WAS' Application.

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

Syntax error converting the nvarchar value '

SELECT

A.Pricelist as [ID], ...

Hi Gail,

I am not too sure how I can do that.Only thing I see is it give the first part of the sql which shows in the broweser after I...

thanks grabber.it works.

Hi sean,

your solution is good,at least it gives one outpurt/claim id but the problem is the description seems appear parially.you what I mean is instead of "Clinical .. ' to...