Need script to scan for six digit order number and date.

November 27, 2012 at 15:04:54
Specs: Windows XP

Bascially we have software creating a text file and I need the "order" number (six digits) and the date, then run a sql query with those variables and append the return to the original text file. Can this be done??

See More: Need script to scan for six digit order number and date.

Report •


#1
December 1, 2012 at 13:32:21

Yes, but the text file would need to be imported into the database. Then a query can be written to scan the db for the required information.

Report •

#2
December 3, 2012 at 20:44:26

You could do it with a simple batch script as long as the system running the script has SQL Server Management Studio installed. If it's not MSSQL, what DBMS are you using?

Tony


Report •

Related Solutions


Ask Question