[dba-SQLServer] John Colby's problem

I think that I mentioned this some time ago, JC. In the context of normalizing those hundreds of columns. But it's all right.

A.



----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: dba-sqlserver at databaseadvisors.com
Sent: Saturday, February 17, 2007 2:45:42 PM
Subject: Re: [dba-SQLServer] John Colby's problem


I just discovered SQL_Variant data type.  I haven't tried using it yet, but
it does seem to solve the "can be any data type" issue for my data store
issue.  The tables now look like:

tblPeople
PE_ID
PE_Fname