On Monday, January 21, 2013 2:15:32 PM UTC-8, Hillary wrote:
>
> I have a query that i'm trying to implement and i'm a bit confused on how
> to use the create_table! method.
>
> drop table #c
>
> select * into #c from table
>
> where Timestamp > GETDATE() - .01
>
You can use the :as option to create_table!:
DB.create_table!('#c'.lit, :as=>DB[:table].where{timestamp > getdate{} -
0.01})
Thanks,
Jeremy
--
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/-/mjsYvwb_HOoJ.
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.
