Old-fashioned solution, works on every version of SQL Server:

-- Check using SELECT

SELECT *

FROM #Temp t1

INNER JOIN (

SELECT Name, DOB, Sex = MAX(Sex), Race = MAX(Race), Height = MAX(Height), Weight =...

You're welcome. Thanks for the feedback. If you have any questions about the solution, post back.

Here's a guess:

-- ALWAYS check first using a SELECT

SELECT

l.rack, l.bay, l.height, l.qty, x.TotalStock, x.Warehouse, x.Bin

FROM [SLGWarehouseLayout] l

CROSS APPLY (

SELECT SUM(i.QtyOnHand1) AS TotalStock, i.Warehouse, i.Bin

FROM InvMultBin i

WHERE i.Warehouse IN...

The inner select is uncorrelated - it will update every row of the target.

Which table contains column QtyOnHand1?

djj (4/7/2014)

---

Because I forget about CROSSAPPLY as I have not used it as often...

What do you want your output table to look like, using the sample data you've provided?

SQLRNNR (4/4/2014)

---

Sean Lange (4/4/2014)

---

TomThomson (4/3/2014)

---

Steve Jones - SSC Editor (4/3/2014)

---

Revenant (4/3/2014)

---

Sean Lange (4/3/2014)

---

This...

"Running totals": ssc has a brilliant article by Jeff Moden here[/url] which covers most of the methods currently used.

In the users_transaction table or the users table? Assuming the former, because we...

Yes, but I've not observed this before. I can't see anything obvious in the plans either. If you have...

As an aside, it seems odd that you are searching so many of those columns. Can you show us what the data looks like?

jasona.work (3/31/2014)

---

ChrisM@Work (3/31/2014)

---

Way back in the early 90's many of us FoxPro programmers waited with bated breath for MS' release of a product which included a crude implementation of SQL....

andrew gothard (3/29/2014)

---

ChrisM@Work (3/28/2014)

---

WayneS (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces of sh...

Revenant (3/28/2014)

---

TomThomson (3/28/2014)

---

Ville-Pekka Vahteala (3/28/2014)

---

TomThomson (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these...

Sean Lange (3/28/2014)

---

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

ChrisM@Work (3/28/2014)

---

Sean Lange (3/28/2014)

---

dwain.c (3/28/2014)

---

Ville-Pekka Vahteala (3/27/2014)

---

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database...