DROP TABLE #Departments

CREATE TABLE #Departments (deptID INT, areaID INT, IsActive TINYINT)

INSERT INTO #Departments (deptID, areaID, IsActive)

SELECT 102, 20, 1 UNION ALL

SELECT 103, 20, 1 UNION ALL

SELECT 104, 20, 1 UNION...

This uses the original data set:

-- change the name of the working table to #_hhrsales2 for testing

-- add a new column ([original_cost] [money] NULL) to the working table

-- There's no...

There are a few errors in here - the only one which appears to matter is the CREATE INDEX..statement which references a column which doesn't exist...

Lovely job LadyG, thanks for this!

Jeff Moden (7/22/2010)

---

Chris Morris-439714 (7/21/2010)

---

Even if there is a clustered index on the table in the order that the update is supposed to be executed, there's no guarantee that the...

Yes thank you, but there is still no script to populate a table with data to use for testing.

Typically it would be something...

No PM received. Without table creation scripts and some sample data, it's difficult to proceed.

LadyG (7/22/2010)

---

The problem is with the last part of the script, insert & select. Obvioulsy, as new_cost doesn't exist in the sales table, the calculated data needs to go somewhere...

In the absence of scripts to create the tables and populate them with data, it's very difficult to tell.

You will need at least one new column, probably oldcost. If you can...

You're welcome Matt, thanks for the feedback.

SELECT MyPrettyNumber = REPLACE(STR(MyNumber*100,11,0), ' ', '0')

FROM (

SELECT MyNumber = CAST(11.24 AS DECIMAL(18,6))

UNION ALL SELECT 100.290000

UNION ALL SELECT 1000.290000

) d

The changes I've...

Jeff Moden (7/20/2010)

---

Chris Morris-439714 (7/20/2010)

---

The UPDATE of the table is a special kind called a Running Totals Update. Jeff Moden has written some excellent and easily consumable articles about them...

Forget table 1 with the ID, it's meaningless and...