By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,815 Members | 1,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,815 IT Pros & Developers. It's quick & easy.

SQL Distinct

P: n/a
What should be the SQL Query syntax to get the result:
Basicaly it's a dinstinct on "Name" but the DocUNID is always quicking in

Query not working: SELECT DISTINCT sysEnum.Name, sysEnum.docUNID FROM
sysEnum ORDER BY sysEnum.Name ASC;

Desired Results:
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType


Here is the table "sysEnum"
DOCUNID
Name

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType
{0E3AA5C8-953F-4146-A7EB-92164100C67A} UserType
{942CCCB1-CBCB-4B47-8BA6-EF34CEA1DA03} UserType
{5CA375D8-87ED-4FE3-83B9-4098CC3AB73E} UserType
Thanks for the help
Nicolas
Mar 22 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"Nicolas" <nl*****@hotmail.com> schrieb
What should be the SQL Query syntax to get the result:
Basicaly it's a dinstinct on "Name" but the DocUNID is always
quicking in

Query not working: SELECT DISTINCT sysEnum.Name, sysEnum.docUNID
FROM sysEnum ORDER BY sysEnum.Name ASC;

Desired Results:
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType


Here is the table "sysEnum"
DOCUNID
Name

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType
{0E3AA5C8-953F-4146-A7EB-92164100C67A} UserType
{942CCCB1-CBCB-4B47-8BA6-EF34CEA1DA03} UserType
{5CA375D8-87ED-4FE3-83B9-4098CC3AB73E} UserType

Actually this is a SQL question, not a VB.Net question, but...
Why is it

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType

not

{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType

?
Armin
Mar 22 '06 #2

P: n/a
This is an enumrator table so I got one table for the enumator per say and
another table with the enumerator name that is is to be use with custom
globalization for title
This should list the type of enumerator
DocUNID
Name DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
"ListType" Type of List Type de liste
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
"ModuleList" List of Module Liste de modules
This is the global Table for all enumerator
Then I got the other table for those enum
DocUNID
Name ID DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType 0
Item1
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType 1
Item2
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType 2
Item2
{CC626E01-A3AE-444B-BB89-075DEF192725} Module 0
Module1
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module 1
Module2
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module 2
Module3

"Armin Zingler" <az*******@freenet.de> wrote in message
news:ur**************@TK2MSFTNGP09.phx.gbl...
"Nicolas" <nl*****@hotmail.com> schrieb
What should be the SQL Query syntax to get the result:
Basicaly it's a dinstinct on "Name" but the DocUNID is always
quicking in

Query not working: SELECT DISTINCT sysEnum.Name, sysEnum.docUNID
FROM sysEnum ORDER BY sysEnum.Name ASC;

Desired Results:
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType


Here is the table "sysEnum"
DOCUNID
Name

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module
{7928EE15-C6B2-4F53-B9C9-7B8BED227574} UserType
{0E3AA5C8-953F-4146-A7EB-92164100C67A} UserType
{942CCCB1-CBCB-4B47-8BA6-EF34CEA1DA03} UserType
{5CA375D8-87ED-4FE3-83B9-4098CC3AB73E} UserType

Actually this is a SQL question, not a VB.Net question, but...
Why is it

{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType

not

{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType

?
Armin

Mar 22 '06 #3

P: n/a
"Nicolas" <nl*****@hotmail.com> schrieb im Newsbeitrag
news:eV**************@TK2MSFTNGP10.phx.gbl...
This is an enumrator table so I got one table for the enumator per say and
another table with the enumerator name that is is to be use with custom
globalization for title
This should list the type of enumerator
DocUNID
Name DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
"ListType" Type of List Type de liste
{CC626E01-A3AE-444B-BB89-075DEF192725} Module
"ModuleList" List of Module Liste de modules
This is the global Table for all enumerator
Then I got the other table for those enum
DocUNID
Name ID DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType 0
Item1
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType 1
Item2
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType 2
Item2
{CC626E01-A3AE-444B-BB89-075DEF192725} Module 0
Module1
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module 1
Module2
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module 2
Module3

Sorry, but it's hard for me to recreate the columns from this posting. Also
always use a fixed-width font in newsgroups. What ist the column DocUNID and
what is Name?
Armin

Mar 23 '06 #4

P: n/a
Thanks for try to help, I got the answer from another news group as you
mention SQL newsgroup
Here is the answer:

SELECT Max(CAST(sysEnum.DocUNID AS VARCHAR(50))), SysEnum.Name
FROM sysEnum
GROUP BY SysEnum.Name

Nicolas

"Armin Zingler" <az*******@freenet.de> wrote in message
news:OQ**************@TK2MSFTNGP11.phx.gbl...
"Nicolas" <nl*****@hotmail.com> schrieb im Newsbeitrag
news:eV**************@TK2MSFTNGP10.phx.gbl...
This is an enumrator table so I got one table for the enumator per say and another table with the enumerator name that is is to be use with custom
globalization for title
This should list the type of enumerator
DocUNID
Name DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType
"ListType" Type of List Type de liste {CC626E01-A3AE-444B-BB89-075DEF192725} Module
"ModuleList" List of Module Liste de modules
This is the global Table for all enumerator
Then I got the other table for those enum
DocUNID
Name ID DefaultValue en
fr es
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ListType 0
Item1
{E0F887EA-7573-4D00-9DE2-43D68435F9CB} ListType 1
Item2
{BB83F135-608E-4104-A5A4-2E1D26AEE6DA} ListType 2
Item2
{CC626E01-A3AE-444B-BB89-075DEF192725} Module 0
Module1
{3C6A6B47-1DCE-42CB-8859-66D6BAB479B5} Module 1
Module2
{CF7678C2-39BE-4A7A-9695-48445C99C8FF} Module 2
Module3
Sorry, but it's hard for me to recreate the columns from this posting.

Also always use a fixed-width font in newsgroups. What ist the column DocUNID and what is Name?
Armin

Mar 23 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.