On Jul 15, 2:39 pm, David Gardner <dgard...@creatureshop.com> wrote: > take a look > at:http://www.sqlalchemy.org/docs/reference/sqlalchemy/expressions.html?... >
Now, Could you give me an example of it ? I understand how to run func to get values like current timestamp, or count....but how to run a stored proc? print func.assp_Report_DailyTransactions(start_date='20100701',end_date='20100715') ?????????? Is this the format? or? Thanks, Lucas > On 07/15/2010 12:29 PM, Lukasz Szybalski wrote: > > > > > Hello, > > I need to get data out of sqlserver by running this stored procedure. > > From there I convert few fields and add the processed rows to a mysql > > table that I have created. > > > How can I do the following in sqlalchemy? Is there a pythonic way? > > Assuming I already have the database connection? What would be the > > syntax to run a stroed procedure? And what object would the results be > > in? > > > USE [Reports] > > GO > > > DECLARE �...@return_value int > > > EXEC @return_value = [dbo].[assp_Report_DailyTransactions] > > �...@start_date = N'07/01/2010', > > �...@end_date = N'07/15/2010' > > > SELECT 'Return Value' = @return_value > > > Thanks, > > Lucas > > -- > David Gardner > Pipeline Tools Programmer > Jim Henson Creature Shop > dgard...@creatureshop.com -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.