Creating remote device output files for testing

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:

F00272810,04/03/2015,07:41:44
F00272811,04/03/2015,07:41:44
F00272812,04/03/2015,07:41:44
F00272813,04/03/2015,07:41:44
F00272814,04/03/2015,07:41:44
F00272815,04/03/2015,07:41:44
F00272816,04/03/2015,07:41:44
F00272817,04/03/2015,07:41:44
F00272818,04/03/2015,07:41:44
F00272819,04/03/2015,07:41:44
F00272820,04/03/2015,07:41:44
F00272821,04/03/2015,07:41:44
F00272822,04/03/2015,07:41:44
F00272823,04/03/2015,07:41:44

Now I need to insert locations, copy and paste to a text file and I can process the data.

Leave a thought