Re: help with this simple proc?

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 6 May 2003 12:11:06 +0200
Message-ID: <1052215457.597187@news.thyssen.com>

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schrieb im Newsbeitrag news:E2F6A70FE45242488C865C3BC1245DA703A34A86_at_lnewton.leeds.lfs.co.uk...
> Morning Gents,

(snip)
> You can try it for yourself using the SCOTT schema, try selecting 10% of
> the EMP rows, but do it a few times and see how many different numbers
> of rows you get back ! I've just tried it using a sample of 10% and got
> the following number of rows back :
>
> 1, 0, 5, 2, 1, 3, 2, 3
>
> all from a 14 row table. I get similar results on my asset table which
> has 1,266 rows in it, the numbers are :
>
> 127, 122, 112, 110, 130, 141, 115, 123
>
> HTH
>
> Regards,
> Norman.

(snip)

Hi Norman,

thanks for the information. I can confirm this behaviour. Looks a bit weird to me.
Is anybody out there who knows why this happens?

Greetings,
Guido Received on Tue May 06 2003 - 05:11:06 CDT