Forum Discussion

jvandyck's avatar
jvandyck
Helper IV
4 years ago

Dynamic queries

Hi   I have a table with a number of flags, called "Flags". This table contains a number of basic flags, but also a number of flags based on a combination of basic flags. An example is loaded in t...
Need Help
smpa01's avatar
smpa01
Community Champion
4 years ago

jvandyck  will the SELECT statement always contain same set of columns per indicator?

SELECT [tf_createdate],
       [tf_jobid],
       [tf_source],
       [tf_sourcefilename],
       [tf_partition],
       [nk_odn_iden_no],
       [nk_pty_iden_no],
       [fl_npsn_adr_email_juist_patroon],
       [fl_nt_npsn_adr_email_ingevuld],
       [fl_nt_npsn_adr_email_juist_patroon]
FROM   [BI_Temp].[Draft].[jvd_onderneming_ckb_base_flag]
WHERE  [fl_nt_npsn_adr_email_juist_patroon] = 1
        OR [fl_nt_npsn_adr_email_ingevuld] = 1