Every so often I need to test something with remote device processing, today happens to be one of those times. I could print some barcodes, scan them, and then process the device.
Here is another way and can get a lot more test data, using the existing data in the database and formatting the data:
SELECT TOP 1000 Barcode + ',' + CONVERT(varchar,GetDate(),101) + ',' + CONVERT(varchar,GetDate(),108) as RemoteTestData FROM tbl_Folders
That results in:
Now I need to insert locations, copy and paste to a text file and I can process the data.