Do you need to actually STORE this data inside SQL Server first (the original record) and then later you want to be able to create the output you list above with a SELECT statement? And if so, does that output eventually get converted into JSON format or does it get consumed in Tabular Datastream format? We need you to provide us with more details so we can help you more effectively!