Thanks for the reply...

Instead of doing an Update query if I write a insert query will the same work. And also do I need to ensure some kind of isolation...

Thanks for your reply

Before I do the update query I am checking if the Balance is greater or equal to the Purchase amount

select @Balance = Balance ...

Thanks for the replies. I am sorry if I couldn't explain earlier but the last column is the amount and not the count that I want.

Basically I just want to...

what do you mean by laoding the data into a working table and then insert it as a batch from that table.

Can someone give me a small sample example?

Thanks.

Thanks but its still giving an error

Column 'tbl.ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

But I also want to display CADD,CScore along with CNAME

But after going to query in access, can we create the stored procedure using

Create Procedure ProName

Begin

End

just as we can do in sql server 2000.

I have a asp.net frontend page...

I am using a OLEDB connection

I login to the server(which has IIS installed) using a userid "ABC" and my sql server database login is "XYZ"

and when I request my asp.net...

Ok got it

Thanks all

No luck it still shows as 13.3333333333333 and not 13.33

Thanks but no I do not want it to be always .00?

example if Elevation/Height (40/3)=13.33 the result should be 13.33 and not 13.00