Can someone please solve this!!??

Thankyou very much didnt realise!

Can anyone help with this???

CREATE TABLE #mytable

(

AccountID NVARCHAR(255) NULL ,

CompanyName NVARCHAR(255) NULL ,

Address1 NVARCHAR(255) NULL ,

Address2 NVARCHAR(255) NULL ,

Address3 NVARCHAR(255) NULL ,

[Town City] NVARCHAR(255) NULL ,

County NVARCHAR(255)...

Sorry took me a while!

see below:

CREATE TABLE #mytable

(

AccountID NVARCHAR(255) NULL ,

CompanyName NVARCHAR(255) NULL ,

Address1 NVARCHAR(255) NULL ,

Address2 NVARCHAR(255) NULL ,

Address3 NVARCHAR(255) NULL ,

[Town City]...

sorry better view of sample outpout for random table:

[/url]

Ideal Output would be for below sample:

COLUMN NAMETotal_RecordsTotal_Distinct_Records% PopulatedMax ValueMin ValueField Type

AccountID3030100%12341INT

CompanyName3025100%etcetcvarchar

Address1302066%etcetcchar

Address2272066%etcetcnvarchar

Address3315etcetcetc

Town City14125etcetcetc

County17115etcetcetc

Postcode30305etcetcetc

Postal Area30305etcetcetc

ContactID30305etcetcetc

Contact_DateLastModified30305etcetcetc

Title2645etcetcetc

FirstName2295etcetcetc

LastName30305etcetcetc

JobTitle22225etcetcetc

JobFunction22225etcetcetc

JobLevel22225etcetcetc

isPersonal22225etcetcetc

ContactStatus2535etcetcetc

Turnover225etcetcetc

Num Employees At Site14145etcetcetc

Num Employees In Group14145etcetcetc

UKSIC20031455etcetcetc

LocationType14145etcetcetc

Typical sample data could be(hope this works):"AccountID","CompanyName","Address1","Address2","Address3","Town City","County","Postcode","Postal Area","ContactID","Contact_DateLastModified","Title","FirstName","LastName","JobTitle","JobFunction","JobLevel","isPersonal","ContactStatus","Turnover","Num Employees At...

Its address data mainly i deal with....

so theres alot of nulls all over the show across all the columns(except the primary key say).

Does this make sense?

The maths would...

Hi,

Thanks for the quick response!

% filled i mean -

say theres a 1000 rows and theres 500 records populated and 500 not, the percentage filled would be 50%.

Thanks