in reply to how to save data to new array after retrieving from sql server

G'day mhoang,

"push @table,@row; #### This is the place I dont know how to save"

If you wrote that as

push @table, [@row];

your output would look more like

$VAR1 = [ [ 'Wellbeing Office ', 'Pending ' ], ... [ 'C303 ', 'InProgress ' ], ];

Now each row is a discrete arrayref, ready for whatever subsequent processing you need to do.

— Ken