Search results for query: *

No output changes I expect. The actualy code in the procedure changed back.

So, we have been having this really weird problem. We have had some stored procedures revert back to old versions seemingly on their own. Here is one example (very detailed). On Friday, I identified two bugs in one of my procs where I had an issues with the dates and a problem in some logging...

OK post the proc it might help.

Do you store Latitude\Longitude of each Postal code? Is that what you are using to determine distance?

Roughly (you might want to double check some of the syntax) Create PROC usp_GetZip @PostalCode varchar(7) AS BEGIN IF len(@PostalCode) = 5 BEGIN Select Column from ZipCodeUS where ZipCode = @PostalCode END ELSE BEGIN Select Column from ZipCodeCanada where ZipCode = @PostalCode END END...

First a little about our environment. We have 4 servers (think Federated data). Server 1 is the traffic cop and contains a database with all of the information used by the applications telling them where to get data (which server and which databases on that server). Server 2 is our ETL...

Did MS in it's infinite wisdom recently update Windows XP and is now blocking the MS Reporting Services 2005 print control? I had it installed and working on my computer just fine. Last week I did a large number of updates on my computer, and now I get the Unable to Load Print Control error...

Hmm, makes me wonder. If you open a check on Terminal 1 and move to terminal 2 and try to open it how does it get that check information (it can't be in memory on both computers come on these are terminals not high in workstations lol). What I am trying to figure out is how to handle split...

Interesting! Thanks!

OK, sounds good. Now my next question...how is that loaded into Memory? What function/stored proc/view is called to pull up all of the information on a check?

What view or Stored Procedure is called when a Check is printed?

I am having an interesting behavior on one of my MS SQL 2005 (Enteprise Edition) databases. First, we are using a Partition scheme to partition several tables by month. Here is the situation. Over the last several days I have had several AutoGrow events (ondata files not log file). Last...

Yes we have authority, and we actually found and resolved the the problem. Thanks you

I will clarify, thanks. We are intercepting payments and doing some processing identifying and applying some discounts. Once we have done that processing we are sending the new data on for payment. So for example, we have a button called Visa, but instead of it automatically sending the...

We are having a weird problem where when we try to apply a payment via code (using ApplyPayment(....)) the payment is not getting a standard Auth Code it is getting a "Force" authorization code. It appears we are sending the entire mag strip (which we have been told may be part of the problem)...

We have added Interactive Sort to several of our reports, but our users are complaining that upon first click the sort is always in asc order. Is there a way to tell it to sort desc by default?

OK I have a weird one here. We are offering some of our customers a discount based on their purchases (via code called with FOH COM) when the employee during the Close Check process. We do NOT want the employee to have to click the Comp button to select the comp. I have successfully figured...

Unfortunatly I enheirited the code and trying to modify it to meet a new requirement. What is the easiest/best way to get a check, and parse through it evaluating each item in the check?

I am trying to parse the through a check to look at all of the items that a customer has ordered and do some other processing if certain items are ordered. Right now I am just trying to loop through it and just msgbox out each item on the check, but.... The code below is throwing an error...

I am doing some BOH Development and am looking for a copy of the BOH Developers docs. Does anybody know where I can find a copy?