Ms-sql

I want to display all the items and its quantity.have same month and different year of purchase in a same column. if the item doesnot sold in a year on that place that item's quantity is zero.

Quote:

Originally Posted by srikanmani

I want to display all the items and its quantity.have same month and different year of purchase in a same column. if the item doesnot sold in a year on that place that item's quantity is zero.

Hi
Can you explain me your requirement clearly.
And send your code what you tried