I"m trying to port the following to use Sequel , what follows is a stored
proc snippet:
SELECT COUNT ( * )
, MAX ( col1 )
, MAX ( col2 )
, MAX ( col3 )
INTO row_cnt
, curr_timestamp
, entry_terminal
, entry_time
FROM my_table
WHERE event_nbr =
row .event_nbr
AND event_date =
row .event_date;
I can figure out how to break these up into separate statements but that
would mean more roundtrips to the db
I also know how to do plain multiple selects thanks to help on a previous
post, can't readily see if I can chain thing up as illustrated in the
stored proc snippet above.
thanks in advance,
-Charles
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/g9GHIc63yVcJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
