In the past I have used EAV tables for something like this. Basically you set up an attributes table (id, name, owner_id, applies_to_id) where the owner is the id...

In recovery means that SQL Server tried to roll forward/back transactions that were not completed when the SQL Server was shut down and could not.

Is the mdf file actually...

What were you attempting to do when you received the error?

Unless you removed the name you have an unnamed mdf file which is probably why you are having the problem.

May I ask why you have a one column table that contains data that should be in multiple columns?

I don't see an insert into the p&l table anywhere in the code you provided.

It would appear that your join between tblBargains and tblStocks is returning multiple rows because...

Use Gail's solution. Mine didn't handle values with .00 correctly.

Not to mention hers is cooler.:P

Also the data may not have been cached in memory on first execution so you had to do physical reads, which are slower than logical reads. While the data...

Sounds like a typo. In SSMS open a new query window, type select * from and then drag and drop the table name from the object explorer to the...

Not an expert on mirroring, but it sounds like your SQL Server(s) are not using domain accounts to run and they may need to for mirroring.

Waiting to see how you solve this one, Gail. I'm sure it will be better than mine.

Well, that's a problem obviously if you are talking about using AD groups to manage security then whoever is managing it has to have rights to modify AD.

As far as...

Something like this would work:

Case

When amount - Convert(int, amount) <= 0.5 then Convert(int, amount) + 0.50

Else Convert(int,...

Can you provide the code that is performing the update, both .NET and SQL?

Have you tried running the update outside the .NET application?

Have you tried running Profiler when doing this...

You have posted in an inappropriate forum. You would have gotten better results if you had posted in the appropriate forum.

You also need to provide the code you are...

Can you post the code for the stored procedure?

Have you tried running the code within the stored procedure outside the stored procedure to see what line is producing the error?