Actually both are required in addition of the sample data and required output from that data.

1.0 : converts to a decimal

*100 : so it shows 65.98 instead of 0.6598

I can see the confusion .

No need for a UDF :

SELECT (col1 * 1.0/col2 * 100) AS percentage FROM table1

That's a good point but what does the identity have to do with rowcount?

Well yes there is, but probably not for what you need.

Can you take the time to post some sample data and the exact required output from that data.  We'll get...

Does this solve your problem?

Select product_id, product_name, units_in office  + units_at owner  + units_on sale AS Total from dbo.Products

Or this would actually be an approved use of the identity propriety by our friend Joe Celko... but I wouldn't add the identity without the date.  I can't explain why, but that's...

Ya but you still have to recreate the whole db somehow without losing any data.  I'm sure there's a way to automate this task without causing too much grief on...

I've pretty much run out of options at this point.  The best way you have to see the problem is to use the debug option in query analyser and go...

Without even going to 3 gig.  Asking fro an extra 2 gig (around 200$) to improve your moral and performance is not a waste of money.  Especially if you can...

So what are you suggesting?

3 gig of ram + 1 gig swap?

Assuming the code works.  Is it possible you have a deadlock somewhere?

Or is it possible that you have a silent failure in the child procedures?

Do you have triggers on any...

I think Mohammed is right.  However have you tried simply deleting the UDTs?

If that doesn't work maybe you would be able to just unbind them which would be much faster...

Soryr for the incomplete answer but that should be enough to get you started.

I'm assuming here that you have a numbers table set up (with the numbers from 1 to...