UPDATE Method

Hot Topic

Error installing Express Edition with VS2005 Standard
Managed Stored Procedures (GetClusterDiscrimination) Crash - any suggestions?
SSRS 2005 asking for credentials when the site is running under annonymous access
Checking to see if a record exists and if so update else insert
Server: the operation has been cancelled. - when processing cube
Sorting parameter listbox on analysis services datasource
How to ZAP a table?
SQL Esxpress Setup is slow as hell
SQL SERVER 2005 Backup
problem with rank on freetexttable

SQL Server

Need help on this MDX query
Transactional Replication - Pull Subscription Snapshot being applied continuously
Stacked bar chart with two bars grouped
Concatentate sorted strings
Help! Create index with substring
CLR Stored Proc Queue activation help
Programming Reports against using Report Builder
how to create a new database from an existing database saved to an external hard disk?
SET NEW_BROKER statement hangs system
SQL Execute Task

UPDATE Method

I have a column of values in one table that needs to be updated based on an adjustment factor in another table. The table which contains the adjustment factors is built with the following column names.

RangeBeg RangeEnd Factor

The factor is determined depending on where the value falls in the range. I have been trying to do an sql script with no luck. Any Help would be appreciated.

Thanks

Answer this question

UPDATE Method

  • Diamantregen

    Hi,

    this could be something like (just guessing because we really need the DDL and some sample data to see how your actual design is working):

    UPDATE SomeTable
    SET SomeValue =
    (
    SELECT SomeUpdateValue FROM AnotherTable AT WHERE ST.SomeRangeValue BETWEEN AT.RangeStarting AND AR.RangeEnding
    )
    FROM SomeTable ST

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • nick5454

    Can you post your script

  • PedroSimao

    Jens,

    Thank you. This answered my question.

    Ken
  • UPDATE Method
Answer this question