Dan
PROJECT TEMPORARY TABLE TemporarTableName usi all where ……..
SEL COUNT(*) INTO vrows FROM TemporarTableName
SET TIME FOR HH:MM:SS.SSS
SET VAR vRowSelect = (IFRC(.#TIME))
LABEL ChkRowCount
IF vRowSelect > .vRow THEN
SET VAR vRowSelect = (IFRC(.#TIME))
GOTO ChkRowCount
ELSE
SEL ……. FROM TemporaryTable WHERE COUNT = .vRowSelect
ENDIF
Make sure to set your TIME FORMAT back to your defaut setting.
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of
Dan Goldberg
Sent: Tuesday, August 9, 2016 1:06 PM
To: [email protected]
Subject: [RBASE-L] - pick a random row
I have a select statement that I need to create that will pick one random row
based on the where clause.
SELECT *FROM averyweb_items WHERE iditemscategory = 4 AND itemsstatus = 1
I can do a random function but not sure on how to implement it.
I cannot figure out what I need to do. Any help is appreciated.
TIA
Dan Goldberg
MIS Manager
Lance Camper Mfg. Corp
(661) 949-3322 Ext 252
www.lancecamper.com <http://www.lancecamper.com/>
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected]
<mailto:[email protected]> .
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
