I literally had the same issue last week, and just filtered in Excel for the
sake of time. Would love to see some SQL magic to do the trick.
Daniel Ratliff
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Krueger, Jeff
Sent: Tuesday, April 22, 2014
I had a report somewhere for that. I'll see if I can dig it up...
-Phil
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Daniel Ratliff
Sent: Tuesday, April 22, 2014 11:32 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Get the SYSTEM_OU_NAME
@lists.myitforum.com
Subject: [mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows
I had a report somewhere for that. I'll see if I can dig it up...
-Phil
From: listsad...@lists.myitforum.commailto:listsad...@lists.myitforum.com
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Daniel Ratliff
Sent: Tuesday, April 22, 2014 11:32 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows
I literally had the same issue last week, and just
select FieldName from daTable
where length(FieldName) =
( select max(length(FieldName)) from daTable )
or
ORDER BY LENGTH(FieldName) DESC and use LIMIT 1
Sent from Windows Mail
From: Daniel Ratliffmailto:dratl...@humana.com
Sent: Tuesday, April 22, 2014 11:56 AM
To:
...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Schwan, Phil
Sent: Tuesday, April 22, 2014 11:43 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows
Older (CM07), but still applicable logic:
http
6 matches
Mail list logo