Re: Drug Testing....

[Sharon Bennett <sbennett@SOFTWAREARCH.COM>]

I for one enjoy the occasional smile while at work. Although I don't post to
this group, I do find the members to be professional and quite frankly your
question was technically not an SQR question.

-----Original Message-----
From:   Discussion of SQR,             SQRIBE Technologies's database
reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Ugandhar
Mukkamala
Sent:   Wednesday, July 21, 1999 4:34 PM
To:     Multiple recipients of list SQR-USERS
Subject:        Re: Drug Testing....

It seems that there was some confusion related to my question regarding
third party vendors; please allow me to elaborate.
I am currently on a project where we require an interface with a third party
vendor for the purposes of drug testing.  Although, technically we can do
this in-house, the client would like to outsource this module due to its
sensitive nature.  I am looking for any vendor if there is any available,
who would be able to chose candidates from the employee population for
random drug testing.

It is rather unfortunate that in a usergroup created to allow the free flow
of information I received so much invective commentary regarding a benign
question.  I hope that this time my question elicits responses worth
reading; only the messages from krisjanis p. gale and Mike J. attempted to
resolve my question.  It is rather unfortunate that responsible members of
society behave in such a manner.  I'd like to apologise for any
inconvenience that I may have caused as well as thank those of you who
replied with messages that were worth reading.  Thank you.



I think you've got the wrong user group

Gracen Duffield
Texas Department of Housing and Community Affairs
475-3839


be careful how you word questions like that,
especially in technical groups like these ;-)

i don't really know of a third-party product that does random selects.
so here's what you do:  make one.
just write a keen little SQR script that selects a certain
number of employees, by randomly selecting from a list of EMPLID's.
shouldn't prove too difficult.
if you need a random number generator, i've got one
written in SQR (my own homebrew), as well as an Oracle Package
for random number generation (you can select from it using DUAL).

(kris)janis p. gale
hrsd - federal reserve bank of new york
x8163

>i don't really know of a third-party product that does random selects.
>so here's what you do:  make one.


Random selects of this type can be a little tricky - for example, do you
want to exclude someone once they have already been selected? If, by chance,
somebody is selected twice in a row, they may been they are being singled
out, or their co-workers may come to suspect them of having failed the
earlier test.

You also may want to log how the selects are done, lest someone accuse the
operator of the script of just running it repeatedly until the desired
outcome is reached.

MikeJ

That's funny, Buddy

>-----Original Message-----
>From: Buddy Sandridge [SMTP:Buddy.Sandridge@GEAC.COM]
>Sent: Wednesday, July 21, 1999 8:58 AM
>To:   Multiple recipients of list SQR-USERS
>Subject:      Re: Drug Testing....
>
>You know, I had presumed he wanted to have the list tested based on some
>of the
>question/responses we get sometimes.... :)
>
>Buddy.


>From: "Manning, Shinta" <shintamanning@NFISG.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Re: Drug Testing....
>Date: Wed, 21 Jul 1999 09:50:32 -0500
>
>That's funny, Buddy
>
> > -----Original Message-----
> > From: Buddy Sandridge [SMTP:Buddy.Sandridge@GEAC.COM]
> > Sent: Wednesday, July 21, 1999 8:58 AM
> > To:   Multiple recipients of list SQR-USERS
> > Subject:      Re: Drug Testing....
> >
> > You know, I had presumed he wanted to have the list tested based on some
> > of the
> > question/responses we get sometimes.... :)
> >
> > Buddy.
> >
> >
> >
> > be careful how you word questions like that,
> > especially in technical groups like these ;-)
> >
> > >>> Ugandhar Mukkamala <solvesqr@HOTMAIL.COM> Tuesday, July 20, 1999
> > 6:08:44 PM
> > >>>
> > Can any body tell me about any third party vendor who will do random
> > selection for drug testing.


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com