"Distinct" statment still doens't change the fact that you don't need an
aggregate function to do "Group By".
And even with a Distinct statement my issue is still outstanding on how to
do Grouping on a dataset? In my original email I explained that I want a
"similar" functionality as what a "Group By" statement provides me with in
SQL. If there is a way to use Distinct statement on a dataset or XML, or a
dataview, I would still be happy.
So if you have a solution please let me know ...
Thanks,
Amadelle
"Patrick Steele [MVP]" <pa*****@mvps.org> wrote in message
news:MP************************@msnews.microsoft.c om...
In article <#V**************@tk2msftngp13.phx.gbl>, am******@yahoo.com
says... r u seriously asking me that question?
Yes, I am.
I don't have to have aggregate functions to use a Group by Clause.
True. But you don't need group by to do what you want.
tblAccounts
accountID userID
1 23
2 23
3 23
4 35
5 35
the group by clause that I have will return the following:
UserID
23
35
Look into SELECT DISTINCT.
--
Patrick Steele
Microsoft .NET MVP
http://weblogs.asp.net/psteele