Decrpyt a DB string list in TSQL

Unknown

Decrpyt a DB string list in TSQL

Unknown

Hello,
Im wondering is it possible to decrypt a database stored string list in T-SQL? I tried to convert/cast but it didnt work. For my use case, I want the db table with a list of people and update of a Power BI report with the list of people/count. My intent is to convert the list data in T-SQL to save code in Decisions to save data in a row per record. Thanks.

Unknown

Hi,
Well if the db table was created by Decisions (as the storage for the data structure), then there is a way to do it the relational database way. To do it, have the list of people be stored in a separate table with a relationship linking a single row in the main table with multiple rows (each with a person) in the new table. The new table will store the people as simple strings (one string per row), the data will be in plain text (not serialized), and then be easily added to via INSERT or modified via UPDATE or DELETE.