We're on SQL latest.
r From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K Sent: Monday, April 08, 2013 4:52 PM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** What is your underlying DB, SQL or Oracle? Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ray Palla Sent: Monday, April 08, 2013 3:38 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Results List duplicates - ITSM 7.6.04 ** Monday, Monday; So I have a ticket form with a results list. The query is simple. ('Assignee' != $NULL$) The results list gives me multiples of the same Assignee. Other than grouping the Assignees, is there another way to get a single row for the 'Assignee' field? r Ray Palla Sr. IT/Remedy Consultant http://www.linkedin.com/img/signature/bg_bluefade_195x42.jpg Mobile: 512-917-1739 Time Zone: Central Email: <mailto:ray.pa...@insona.com> ray.pa...@insona.com http://www.linkedin.com/img/signature/icon_in_blue_14x14.gif Professional Profile <http://www.linkedin.com/pub/1/544/598> <http://www.INSONA.com> INSONA Corporation 1201 Berry Lane <http://maps.google.com/maps?q=10650+SW+Plaza+CT%2CBox%3A+J68%2CHouston%2CTX +77074%2CUSA&hl=en> Georgetown, TX 78626-3832 USA Infrastructure Solutions - Network Applications _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<image001.jpg>>
<<image002.jpg>>
<<image003.gif>>