Q&A BY TAG 'denodo7'

You must sign in to ask a question. If you do not have an account, you can register here

Prior year last business day retrivel
answered 24-08-2021 03:11:16 -0400

Hi there, I am trying to retrive last business day of last year though this query select dateadd(yy,datediff(yy,-1,@date),-1)[In sql], but in denodo I am not able to find any solution here, so can you please help me out, Thanks,

Answers: 1

denodo7 query

A subquery is not delegated to the source and facing a timeout
answered 22-07-2021 18:31:52 -0400

In this, the subquery is not delegated to the source because it is executed from dual(). when we execute this full query, it is loading more than 2ml records first (Reason for query timeout) and then it applies the subquery logic in where conditi...

Answers: 1

denodo7 subquery