Tuesday, July 03, 2007

Using DISTINCT in Select Statement

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

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.