create table #cust
(           customerId int null
    ,       accountOpen datetime null
    ,       accountType char(5) null
    ,       baseCurrency char(3) null
    ,       clearedFunds numeric(30,6) null
    ,       client_Data numeric(12,0) null
    ,       month int null
    ,       year int null
)

     create unique index idxc on #cust (customerId)
     create unique index idx2 on #cust (client_Data)