Hi Allen, first thank you for the explanation off the gomonth()-problem, but we are in old Europe ;-) For the median a SELECT DISTINCT don't gives the right value! The Skip is much more easy but returns only the median in uneven counts of records.
Dr. Joerg Arand Consultant Neonatologist Neonatology Children's Hospital University Tuebingen Calwer Str. 7 D-72076 Tuebingen Tel.+49-(0)7071-2982211 Tel.+49-(0)7071-2980895 (office) E-mail:Joerg.Arand(AT)med.uni-tuebingen.de >>> "Allen" <[email protected]> 15.04.2014 13:25 >>> Hi Joerg That is about what I did, but distinct TTOD in the select. I am going to test speed though it's not a big deal. The skip is simple and I hope faster. Will play. Thanks Al -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Joerg Arand Sent: 15 April 2014 13:14 To: [email protected] Subject: Re: halfway down a set order Hi Allen For the median do: select datefield from table into cursor curtemp order by datefield lnrecord=_tally/2 go lnrecord in curtemp IF mod(_tally,2)=1 skip in curtemp retu datefield else lndatetime1=datefield skip in curtemp return lndatetime1+(datefield-lndatetime1)/2 endif _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/008501cf589d$5d2d18a0$178749e0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/008501cf589d$5d2d18a0$178749e0$@com --- StripMime Report -- processed MIME parts --- multipart/mixed multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
