DECLARE branchComparison 
	CURSOR FOR SELECT branch 
	FROM table1
DECLARE @e_branch integer
OPEN branchComparison
FETCH FROM branchComparison INTO @e_branch
WHILE @@FETCH_STATUS = 0
BEGIN
	UPDATE table1 SET branch_count = 
	(SELECT 
	count(distinct calculatedValue)
	FROM   tablea a,
	       tableb b,
	JOIN   tablec c
	ON     b.valueX = c.valueY
	WHERE  b.valueZ > '01/01/2000'
	AND    a.branch = @e_branch
	AND    b.valueC = 1
	AND    c.valueD IS NOT NULL)
FETCH NEXT FROM branchComparison INTO @e_branch
END
CLOSE branchComparison
DEALLOCATE branchComparison

SELECT 
	count(distinct calculatedValue)
	FROM   tablea a,
	       tableb b,
	JOIN   tablec c
	ON     b.valueX = c.valueY
	WHERE  b.valueZ > '01/01/2000'
	AND    a.branch = @e_branch  <--- Which would now be  "AND a.branch = 1"
	AND    b.valueC = 1
	AND    c.valueD IS NOT NULL

quote:

---

Originally posted by Peso

UPDATE		t1 
SET		t1.branch_count = e.x
FROM		Table1 AS t1
INNER JOIN	(
			SELECT		a.Branch,
					COUNT(DISTINCT calculatedValue) AS x
			FROM		TableA  AS a
			INNER JOIN	TableB AS b ON b.ValueZ >= '01/01/2000'
						AND b.ValueC = 1
			INNER JOIN	TableC AS c ON c.ValueY = b.ValueX
			WHERE		c.valueD IS NOT NULL
			GROUP BY	a.Branch
		) AS e ON e.Branch = t1.Branch

---

E 12°55'05.63"
N 56°04'39.26"

---

DECLARE branchComparison
CURSOR FOR SELECT branch
FROM table1
DECLARE @e_branch integer

DECLARE @branch_count INTEGER

OPEN branchComparison
FETCH FROM branchComparison INTO @e_branch
WHILE @@FETCH_STATUS = 0
BEGIN

SELECT @branch_count = count(distinct calculatedValue)
FROM tablea a,
tableb b,
JOIN tablec c
ON b.valueX = c.valueY
WHERE b.valueZ > '01/01/2000'
AND a.branch = @e_branch
AND b.valueC = 1
AND c.valueD IS NOT NULL

UPDATE table1 SET branch_count = @branch_count WHERE branch = @e_branch

FETCH NEXT FROM branchComparison INTO @e_branch
END
CLOSE branchComparison
DEALLOCATE branchComparison

DECLARE branchComparison
CURSOR FOR SELECT branch, code
FROM table1
DECLARE @e_branch INTEGER
DECLARE @branch_count INTEGER
DECLARE @e_code VARCHAR(100)
DECLARE @code_count INTEGER

OPEN branchComparison
FETCH FROM branchComparison INTO @e_branch,@e_code

WHILE @@FETCH_STATUS = 0
BEGIN

SELECT @branch_count = count(distinct calculatedValue)
FROM tablea a,
tableb b,
JOIN tablec c
ON b.valueX = c.valueY
WHERE b.valueZ > '01/01/2000'
AND a.branch = @e_branch
AND b.valueC = 1
AND c.valueD IS NOT NULL

UPDATE table1 SET branch_count = @branch_count WHERE branch = @e_branch

SELECT @code_count = count(distinct calculatedValue)
FROM tablea a,
tableb b,
JOIN tablec c
ON b.valueX = c.valueY
WHERE b.valueZ > '01/01/2000'
AND b.Branch_ID = @e_code
AND b.valueC = 1
AND c.valueD IS NOT NULL

UPDATE table1 SET code_count = @code_count WHERE code= @e_code

FETCH NEXT FROM branchComparison INTO @e_branch,@e_code

END
CLOSE branchComparison
DEALLOCATE branchComparison