sql count distinct for total column - Experts Exchange - The network for technology professionals.

I'm trying to create a box total column in a table by counting distinct cases from multiple columns in the same table. I can do this properly when the box total column ... UPDATE tblWhCoreBoxTotal SET BoxTotal = (SELECT COUNT(*) FROM (SELECT DISTINCT f ..

www.experts-exchange.com