I am kind of exhausted. Can someone shed some light on this?

I have some data that I need to compile to get the following report.
something like this...

Origin Deployed Reconciled Location
10 4 6(10-4) A
10 2 4(10-(4+2)) B
10 2 2(10-(4+2+2)) C
10 0 2(10-(4+2+2)) NULL

Anything that has location data should be considered as deployed. I am finding it difficult to get the reconciled stuff calculated. I have got the thing ready except the Reconciled column. Can someone help me out?

Thanks in advance
Cheers

_________________________
- Vijay G
Strive for Perfection

__________________
- Vijay G

I am fully clear on what you are trying to reconcile. Can you post your statement.


Jaime E. Maccou

This time I am done with my requirement. It was just a 20 mins work. I wrote some functions that I usedin select statement and got it work perfect. I should also have posted the table schemas involved in it. Sorry about that, didn't have much time these days. Happy that I accomplished it.

Thanks for your time.
Cheers.

_________________________
- Vijay G
Strive for Perfection

Please post your solution.

Thanks,
Richard

Functions? Nice little bit of cross-tab logic may have sufficed... depending on how you wrote the function(s), the cross-tab logic might be a little quicker, to boot.

--Jeff Moden