Print ''
Print '-------------------------------------------------------------------------'
Print ' using Database: #DB_N#'
Print ' Action        : JobMgr_90_MaintainDatabase_selectAll_StatusBlank'
Print ' Creation Date : 17.11.2022 /J.Fes'
Print ' LastUpdate    : 17.11.2022 /J.Fes'
Print '-------------------------------------------------------------------------'

use [#DB_N#]


Print '-- [Objects_tbl_MT_UpdateProcStateCol] -------------------------------------'
select ObjectFromSiteID,ObjectClass,ObjectCliName,
           ProcStateCol01,
           ProcStateCol02,
           ProcStateCol03,
           ProcStateCol04,
           ProcStateCol05,
           ProcStateCol06,
           ProcStateCol07,
           ProcStateCol08,
           ProcStateCol09,
           ProcStateCol10,
           ProcStateCol11,
           ProcStateCol12,
           ProcStateCol13,
           ProcStateCol14,
           ProcStateCol15,
           ProcStateCol16,
           ProcStateCol17,
           ProcStateCol18,
           ProcStateCol19,
           ProcStateCol20,
           ProcStateCol21,
           ProcStateCol22,
           ProcStateCol23,
           ProcStateCol24,
           ProcStateCol25,
           ProcStateCol26,
           ProcStateCol27,
           ProcStateCol28,
           ProcStateCol29,
           ProcStateCol30,
           ProcStateCol31,
           ProcStateCol32,
           ProcStateCol33,
           ProcStateCol34,
           ProcStateCol35,
           ProcStateCol36,
           ProcStateCol37,
           ProcStateCol38,
           ProcStateCol39,
           ProcStateCol40,
           ProcStateColRf,
           ProcStateColMc,
           ProcStateColUn
     from dbo.Objects_tbl with (nolock)
     where  (ProcStateCol01 is null or ProcStateCol01 = '')
         or (ProcStateCol02 is null or ProcStateCol02 = '')
         or (ProcStateCol03 is null or ProcStateCol03 = '')
         or (ProcStateCol04 is null or ProcStateCol04 = '')
         or (ProcStateCol05 is null or ProcStateCol05 = '')
         or (ProcStateCol06 is null or ProcStateCol06 = '')
         or (ProcStateCol07 is null or ProcStateCol07 = '')
         or (ProcStateCol08 is null or ProcStateCol08 = '')
         or (ProcStateCol09 is null or ProcStateCol09 = '')
         or (ProcStateCol10 is null or ProcStateCol10 = '')
         or (ProcStateCol11 is null or ProcStateCol11 = '')
         or (ProcStateCol12 is null or ProcStateCol12 = '')
         or (ProcStateCol13 is null or ProcStateCol13 = '')
         or (ProcStateCol14 is null or ProcStateCol14 = '')
         or (ProcStateCol15 is null or ProcStateCol15 = '')
         or (ProcStateCol16 is null or ProcStateCol16 = '')
         or (ProcStateCol17 is null or ProcStateCol17 = '')
         or (ProcStateCol18 is null or ProcStateCol18 = '')
         or (ProcStateCol19 is null or ProcStateCol19 = '')
         or (ProcStateCol20 is null or ProcStateCol20 = '')
         or (ProcStateCol21 is null or ProcStateCol21 = '')
         or (ProcStateCol22 is null or ProcStateCol22 = '')
         or (ProcStateCol23 is null or ProcStateCol23 = '')
         or (ProcStateCol24 is null or ProcStateCol24 = '')
         or (ProcStateCol25 is null or ProcStateCol25 = '')
         or (ProcStateCol26 is null or ProcStateCol26 = '')
         or (ProcStateCol27 is null or ProcStateCol27 = '')
         or (ProcStateCol28 is null or ProcStateCol28 = '')
         or (ProcStateCol29 is null or ProcStateCol29 = '')
         or (ProcStateCol30 is null or ProcStateCol30 = '')
         or (ProcStateCol31 is null or ProcStateCol31 = '')
         or (ProcStateCol32 is null or ProcStateCol32 = '')
         or (ProcStateCol33 is null or ProcStateCol33 = '')
         or (ProcStateCol34 is null or ProcStateCol34 = '')
         or (ProcStateCol35 is null or ProcStateCol35 = '')
         or (ProcStateCol36 is null or ProcStateCol36 = '')
         or (ProcStateCol37 is null or ProcStateCol37 = '')
         or (ProcStateCol38 is null or ProcStateCol38 = '')
         or (ProcStateCol39 is null or ProcStateCol39 = '')
         or (ProcStateCol40 is null or ProcStateCol40 = '')
         or (ProcStateColRf is null or ProcStateColRf = '')
         or (ProcStateColMc is null or ProcStateColMc = '')
         or (ProcStateColUn is null or ProcStateColUn = '')

EndeExit:
 Print '.........................................................................'
 Print ('JobMgr_90_MaintainDatabase_selectAll_StatusBlank: #DB_N# !Done!')
 Print '-------------------------------------------------------------------------'
 Print ''
GO
