Delete all but one column in dataset/table and remove duplicates
Posted on 2014-11-10
Hi guys, I'm pretty new to VB so need some help.
I've got a SQL query which runs and fills a dataset/table. It fills it with a heap of fields; Computer, Location, Floor, Owner, Type...
How can I get it to remove all the fields except "Location" and to then go through the list and remove any duplicates?
Not that it matters, but my dataset/table is sResult2.Tables(0)