paul.biltcliffe 32759 (12/2/2016)
Data Types:a.client = nvarchar(25), not null
a.status = nvarchar(1), not null
a.attribute_id = nvarchar(4), not null
On an unrelated note, why are you using nvarchar(1) for your status instead of nchar(1)? It takes two extra bytes to store and it only makes a difference if you need to differentiate between '' and ' '.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA