DECLARE @tablenames TABLE 
( 
table_id INT IDENTITY, 
table_name SYSNAME 
) 

INSERT INTO @tablenames (table_name) 
SELECT name FROM sysobjects 
WHERE type='U' 

DECLARE @i INT 
DECLARE @tablename SYSNAME 

SET @i = 1 

WHILE (@i <= (SELECT MAX(table_id) FROM @tablenames)) 

    BEGIN 
    SELECT @tablename = table_name 
    FROM @tablenames 
    WHERE table_id = @i 

    EXEC ('GRANT UPDATE ON ' + @tablename 
           + ' TO public') 

    SET @i = @i + 1 
    END

quote:

---

Originally posted by rockmoose

Chesslock, this thread is only like 4½ years old. New record!? for thread resurrection

If you really want quick help on this post the table structure of Inventory and VehicleStockDetails,
and some sample data, and example of what you want to accomplish.
Reading through that cursor code, just gives me a headache.

rockmoose

---

quote:

---

Originally posted by chessclock

Rockmoose,
thank you for your reply!

I have two tables: the Inventory table (some 300,000 records) and VehicleStockDetails (some 30,000 records).
Inventory table has UnitID, StockTicketNumber, WholesalePrice, and UnitCost fields (I omit the other 60 fields). VehicleStockDetails table has VehicleID, StockTicketNumber, and VehicleSalvageCost field.

All zero and NULL UnitCost fields needs to be updated based on the formula:
for each record, a UnitCost = WholesalePrice (of the same record) *
SUM(VehicleSalvageCost) / SUM(WholesalePrice)

Every Inventory (table) record has a WholesalePrice (field) used in a calculation of UnitCost (field to be updated). Also, for every record, two totals (used in a calculation of UnitCost) must be calculated by querying two separate tables (Inventory and VehicleStockDetails) by a StockTicketNumber corresponding to the CURRENT record.
This is why two queries are kind of connected to the cursor.

In MS docs I have found that I can't use more that one SELECT statement when using a cursor (in other words, there won't be any SELECT statements within a cursor). This is why I suspect that my solution (posted earlier) will not work!..

So, the tricky question is:
How can I use cursors (or can I use something else), if I need to update every record using a separate query (two queries) for each record to get the values for the update?

quote:

---

Originally posted by rockmoose

Chesslock, this thread is only like 4½ years old. New record!? for thread resurrection

If you really want quick help on this post the table structure of Inventory and VehicleStockDetails,
and some sample data, and example of what you want to accomplish.
Reading through that cursor code, just gives me a headache.

rockmoose

---

---