Hi Jeremy, is it possible to modify the sql statment in the Dataset object, so I could get rid of that comma? Thanks.
On Thursday, July 12, 2018 at 12:50:54 PM UTC-7, Jeremy Evans wrote: > > On Thursday, July 12, 2018 at 12:32:10 PM UTC-7, lkfken wrote: >> >> Hi Jeremy, >> >> I tried but it's not working >> >> MSSQL raise an error "Incorrect syntax near the keyword 'UNPIVOT'". >> >> It is because a "comma", right after the alias "p1" and before the >> operator UNPIVOT, is found in the SQL statement >> >> Please advise. thank you. >> > > I see. Unfortunately, you'll have to use raw SQL for this query: > DB["SELECT ..."] > > 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 https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
