There should be some description about the order in which you want to see the data.

By looking input and output we can have different meaning unless we know what...

To say which one is better we need to test with million data.

but what is the volume of the data that you have.!

Hi

All the summing operations based on the amount should be part of Front-End.

One Big Reasons behind this:

1) If you have Pagination in UI you would want to display the totals...

Hi

This is one of the challenge. Its always good to have Uniques on Dimension/Enum/Lookup tables.

Hi Flo

Thanks for adding Try and Catch 😉 ..I hope from next time onwrods i will Catch my posting exception 😉

Hi

You can check out the below link

http://www.sqlservercentral.com/articles/Advanced+Querying/2785/

have some discounts for MVPs 😎

* is required only when you are using SELECT operation.

In addition to the above you may want to check out the below link

http://www.sqlservercentral.com/articles/Advanced+Querying/2829/

You can even schedule Jobs using Agent Service.

Lets keep the stored procedure aside..and tell us what is your requirement.

I did implement similar using Metadata tables.

Hi

There is nothing like this in Oracle. this SQLServerCentral is very unique.

Hi

As it stated in previous post you need to use FULL OUTER joing.

Hey Steve..

Any chance to taking over SQL Server also from MS??;-)

Hi

By looking at the query i am sure one wold want o have index in the ID column. So if you place any functions that then that would certainly hit...