Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am working to build some check mechanism on a table where every day say 20200617, sysdate, it will check table A date field (YYYYMMDD) if there are records. If yes then fail the reload so it will send an email alert.
My idea is something like
Count( if( Sysdate = [Date] ) > 1)),
fail
Can anyone help me? Thanks
Like this?
Count(if(Today()= [Date], 1, 0)) // Here, 1 is record is there and 0 is not there
Like this?
Count(if(Today()= [Date], 1, 0)) // Here, 1 is record is there and 0 is not there