Thanks that helped, But in the same lines could you suggest how to get one record per group if the other column is acct_name varchar instead of acct_num.

like

create table #temp1...