Using the MS SQL Server, is there a secret to getting the output to return into an ag grid without a
Using the MS SQL Server, is there a secret to getting the output to return into an ag grid without additional data manipulation, it appears it's adding an extra bracket to the output causing rows to appear as columns.
Example SQL Query:
SELECT 'Row1Col1' as [COL1],
'Row1Col2' as [COL2],
'Row1Col3' as [COL3]
union
SELECT 'Row2Col1' as [COL1],
'Row2Col2' as [COL2],
'Row2Col3' as [COL3]
Output:
[
[
{
"COL1": "Row1Col1",
"COL2": "Row1Col2",
"COL3": "Row1Col3"
},
{
"COL1": "Row2Col1",
"COL2": "Row2Col2",
"COL3": "Row2Col3"
}
]
]
Example SQL Query:
SELECT 'Row1Col1' as [COL1],
'Row1Col2' as [COL2],
'Row1Col3' as [COL3]
union
SELECT 'Row2Col1' as [COL1],
'Row2Col2' as [COL2],
'Row2Col3' as [COL3]
Output:
[
[
{
"COL1": "Row1Col1",
"COL2": "Row1Col2",
"COL3": "Row1Col3"
},
{
"COL1": "Row2Col1",
"COL2": "Row2Col2",
"COL3": "Row2Col3"
}
]
]
