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??
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.
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
