Has anyone experienced discounts working on some line items and not on others? I have tried several ways to get a discount to stick, i.e. I had a very large order and each item had some sort of discount and I tried using the discount key, changing the price and entering the quantity and I tried just typing over the price and quantity then to hit the tender key and have maybe only 4 out of 20 items keep the changes?
This is a real pain!! Does anyone know of any fixes? Help!
Yes on the SP1 level, Microsoft has recreated this problem with me and will create a fix.
As a temporary solution, I created a SQL stored procedure to set OrderEntry.FullPrice to OrderEntry.Price when they are not equal. This procedure runs every hour. If you need a copy of the procedure, let me know.
TomT
Somewhat off topic, but how do you get a proecdure to run every hour? I want to do a SQL query every so often, and it sounds like you know how...
On that note, I was trying to come up with another solution to do a SQL query for sales that is sent to a .txt file that gets saved on my web server so I can access up to date sales information from anywhere on the net. Any thoughts on how to do this? It doesn't have to be pretty - it's just for my own use.
For scheduling, you can either use SQL Server Agent (not sure if it's available in MSDE/Express .. might only be in Standard editions), or you can use the windows scheduler (Starts -> Programs -> Accessories -> System Tools ->
Scheduled Tasks) to run a batch file command, which could then in turn use OSQL.EXE to execute any commands you want to run.
As for saving the results of a query to a text file, in SQL 2000 Standard edition you can use DTS, although in 2005 they phased it out and replaced it with something called SSIS, which I assume has all the same functions as DTS. With DTS you could setup a mapping from a table into a text file, and then use a scheduler or SQL Agent to run that DTS package on a regular basis.
However I don't think any of these features are available in MSDE/Express
Have something to add? Share your thoughts — no account required.
Ask the community — no account required