"Nicolas" <nlie***@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

"Armin Zingler" <az.nospam@freenet.de> wrote in message
news:urxf81fTGHA.1868@TK2MSFTNGP09.phx.gbl...
> "Nicolas" <nlie***@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
>
>

"Nicolas" <nlie***@hotmail.com> schrieb im Newsbeitrag
news:eVOEvJgTGHA.4308@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
>

"Armin Zingler" <az.nospam@freenet.de> wrote in message
news:OQC$RDmTGHA.4976@TK2MSFTNGP11.phx.gbl...
> "Nicolas" <nlie***@hotmail.com> schrieb im Newsbeitrag
> news:eVOEvJgTGHA.4308@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
>