When you use DISTINCT in a Select statement, you are saying that you only want one row in the result set for each distinct set of values. The result set will not have any two rows that have the same values in every column.
Let's say in table SOP30300, you have the following data:
INV001 Items: ABC, DEF, GHI
INV002 Items: DEF, JKL, MNO
INV003 Items: MNO
Then you run this statement:
SELECT DISTINCT itemnmbr
FROM dbo.SOP30300
The result set should be:
ABC,DEF,GHI,JKL,MNO
This blog was created to help Program leads, solution architects and administrators of different enterprise solutions including ERP, CRM, SCM, WMS, PLM, Business Intelligence and many more.
Tuesday, July 03, 2007
Monday, July 02, 2007
2007 Microsoft® MVP Award
Got this last night:
"Congratulations! We are pleased to present you with the 2007 Microsoft® MVP Award! The Microsoft MVP Award is our way of saying thank you and to honor and support the significant contributions you make to communities worldwide. As a recipient of Microsoft's™ Most Valuable Professional award, you join an elite group of technical community leaders from around the world who foster the free and objective exchange of knowledge by actively sharing your real world expertise with users and Microsoft. Microsoft salutes all MVPs for promoting the spirit of community and enhancing peoples lives and the industrys success everyday." Thank you Microsoft for believing in my capability and rest assure that I’ll be extending my hands more to the community this year.
Subscribe to:
Posts (Atom)
e-Commerce discount types
In the world of retail today every retailer is trying to find ways and be creative to attract online customers. To attract your attention an...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display...
-
I've filled out the survey and chose the functionalities I think would benefit a lot of industries. Below is a summary of the survey I s...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...