that worked thanks
On Monday, January 21, 2013 5:01:29 PM UTC-8, Jeremy Evans wrote:
>
>
>
> 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/-/0ho6FM_to9IJ.
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.
