Seen. Thanks for the help guys.

One more thing, it worked just fine. But what slight tweak would you make if you

a)wanted a grand total at the end (im thinking, throw results in a temp...

Thanks Stewart, thanks Paul. Wow Paul, I am speechless. What a solution. Never worked with grouping sets before. Thanks for the introduction.

Thanks for the responses guys, as far as the DR/HA technique, it will be done by someone learning from scratch. No consultants. From what Ive read thus far, seems like...

Thank you for the information Bob.

The business reason behind this is a long story. I also saw it as a way to explore the possibilities of sql. I thought it was impossible that was why...

Hey guys, I have a question about money data types, if his "shippingcost" is to large to be held by the "money" data type what is a better (bigger) option...

Hey Lowell and Gsquared, Thanks for taking time out to help. Quick questions, would that default random number generator code be good for performance (indexing e.t.c)? How would seeding it...

well, maybe not exactly security, but more like preventing some people from guestimating how many goods placed by looking at the id and doing some calculations. How can I implement...