Thank you Eric for your reply.

i will indeed need to leverage on sql server for my solution.

What do u think is a better solution to tackle such requirement other than xml data types or sparse columns?

Thanks.