Hi,
I probably should have asked originally.
How would i select from the temp table.
DB.create_table!('#t'.lit, :temp => true, :as=>
DB[:table].nolock.where{timestamp > getdate{} - 0.01})
Is it something like.
DB[:t].select_map(:some_column) ?
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 unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
