[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

2014-04-22 Thread Daniel Ratliff
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

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

2014-04-22 Thread Schwan, Phil
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

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

2014-04-22 Thread Schwan, Phil
@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

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

2014-04-22 Thread Garth Jones
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

Re: [mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

2014-04-22 Thread Christopher.Catlett
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:

[mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows

2014-04-22 Thread Krueger, Jeff
...@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