On Aug 13, 7:21 pm, dj <[email protected]> wrote:
> I've got a stored procedure on a DB I'm accessing through ODBC (for
> Sequel); when I use it natively, I use this syntax:
>
> Select * from getcrossdata('MSFT', '1986-03-13', '2009-08-12')
>
> (the store procedure, obviously, is 'getcrossdata', and it takes 3
> params, a varchar and 2 dates)
>
> Can you tell me what the equivalent syntax would be w/Sequel? I
> understand there is no guarantee it will work.
That looks like a set returning function and not a true stored
procedure, but my experience with SQL server is limited. You could
try:
DB.from(:getcrossdata.sql_function('MSFT', '1986-03-13',
'2009-08-12')).all
Jeremy
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
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
-~----------~----~----~----~------~----~------~--~---
