Set Analisys

[claudio_reis_we]

Hi,

Can you help me please?

How to implement the script below on a set analysis?

select numcad

from r034fun

where tipcol =1

    and datadm <= '01/03/2016'

    and (sitafa = <> 7 or (sitafa=7 and datafa>='01/03/2016'))

Thanks!

[#2]

what is the dimension . is it num of cad?

[swuehl · Accepted solution]

Maybe like

{

<tipcol = {1}, datadm = {"<=01/03/2016"}, sitafa -= {7}>

+

<tipcol = {1}, datadm = {"<=01/03/2016"}, sitafa = {7}, datafa ={">=01/03/2016"}>

}

[claudio_reis_we]

Hi, Stefan!

It worked!

thanks!