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.
