I have a huge table and would like to know of a way to count field population across the whole table, this can be stored in a separate table to refer back to, i am using sql 2008. A visual display could be:
TableName FieldName Blank Populated MinValue MaxValue DateCreated
Person Address1 1500 5000 <blank> 9 any street 30-sep-2010
Person First Name 6000 500 <blank> Zac
has anyone done something like this before, would like something quite reusable and generic?
any help greatly appreciated.
View Complete Post