Indeed, sql_variant is no option because of the waste of disk space and because it's not supported in SQL Server 7.

I'm just going to stick with the int type...

Well, the values are logged by a scada system, whitch gets the data from an industrial process. This way an enormous amount of data is being logged. So yes, millions...