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

If you are only returning one row for each Name, what
criteria do you need for that one row and the DocUNID
returned for that one row? If you don't care, you can use
something like:
SELECT Max(sysEnum.DocUNID), SysEnum.Name
FROM sysEnum
GROUP BY SysEnum.Name

-Sue

On Wed, 22 Mar 2006 17:56:06 -0500, "Nicolas"
<nliebel@hotmail.com> wrote:

>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
>

Thank you Sue for the help. It works with little modification as DocUNID is
uniqueidentifier

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

Again thank you
Nicolas

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:78942256db8ujbb1ekhc4oantlaoae2bdb@4ax.com...
> If you are only returning one row for each Name, what
> criteria do you need for that one row and the DocUNID
> returned for that one row? If you don't care, you can use
> something like:
> SELECT Max(sysEnum.DocUNID), SysEnum.Name
> FROM sysEnum
> GROUP BY SysEnum.Name
>
> -Sue
>
> On Wed, 22 Mar 2006 17:56:06 -0500, "Nicolas"
> <nliebel@hotmail.com> wrote:
>
> >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
> >
>