I am trying to pivot some row values to a column, below is what I am trying to achieve. My Current Schema: This is what I am trying to achieve: but it skips rows when name and lan have similar values, in this case it skips the row with the name value vsp. Answer this fixes my problem.
Tag: ssis-2012
Is there any way to insert below nested json data into sql server
I am working on a nested JSON data which I need to load into SQL SERVER 2012. The nested JSON contains two roots i.e. one column and another rows. I need to put value from row into the column. Please …