Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: phark
  • Order by date
  1. phark

    Problem Updating a table using CASE

    Here is what ended up working, FYI: [code]update rm20101 set bachnumb = (CASE when custnmbr > '9999' and custnmbr < '11000' then 'BULK-1' when custnmbr > '10999' and custnmbr < '12000' then 'BULK-2' when custnmbr > '11999' and custnmbr < '13000' then 'BULK-3' when custnmbr >...
  2. phark

    Problem Updating a table using CASE

    What I am trying to do, is change data in certain rows in the table RM20101. Most of the data in the BACHNMBR column currently has the value of BULK. I want to change all values in the column BACHNMBR to a different value, based on their customer number (CUSTNMBR). Example: Customer...
  3. phark

    Maintenance in Dynamics 6

    We were using Pervasive up until a year ago, but finally made the switch to MS SQL. We generate about 2,500 invoices a week and the Pervasive was so slow posting and was constantly crashing during posting. A typical batch with say, 50 invoices in it would take 15 to post with Pervasive. In...
  4. phark

    Problem Updating a table using CASE

    I am trying to update a SQL table. Basically, I want to take our customers and move some of their invoices to a different batches. The problem seems to be one account that has a non-numeric account number called CASH. All the other accounts are numeric. Here what I tried to run: update...

Part and Inventory Search

Back
Top