MS SQL 2012 User Entered Data in Query
Posted on 2014-11-27
I'm not sure how to go about doing this. I have a query which reconciles data between two tables and, where the records match, enters the reconciliation date into a column. This is done on a weekly basis, so the date changes each time. At the moment, I'm using a Find and Replace in the query to put the latest date in. Is there any way I can do this by the user entering the date into some kind of input box and the query updating from that? Failing that, could I have the user enter the date into a spreadsheet, import the spreadsheet and then pick the date up as a variable or something?