> >> select * from (procedure_foo) > > > That would be lovely, but I can find no way to wrap a procedure in a > > select. If it were possible I could have just rewritten the procedure > > call as a select and matched the existing regexp. > > you can do that as select(["*"]).select_from(func.procedure.foo()) .
Thanks, I understand that that will generate "SELECT * FROM procedure_foo()"; the trouble is that SQL Server does not permit selecting from procedures in that way. Happily, though, I realized I can create a table-valued function that executes the procedure, and I can select from the table-valued function in this way. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
