Glad I could help 😀

This example once again demonstrate how a "semi-optimal" database design usually increase query complexity...

The sad part is, there are companies out there making money by selling...

Will something like this bring you closer to the result you're looking for?

The information that there will never be more than two UOMs allows to use the ROW_NUMBER approach to...

Did you have a look at my solution?

It shows the result you're looking for (at least after eliminating the undesired columns).

But that still doesn't answer the questions I asked earlier.

stourault (12/22/2011)

---

Thank you guys for the quick response and the ideas here are similar to what I've been testing out but one of the problems I have is that the...

GSquared (12/22/2011)

---

Lutz, that won't get anything that's in both places (if that's possible), nor will it get anything that's in Bins but not in Lots (if that's possible). At...

Here's a slightly different approach. You'll need to reduce it to the columns needed.

SELECT * FROM

(

SELECT

PartCode,

Lot,

Status,

Warehouse,

MAX(CASE WHEN UOM='CS' THEN Qty ELSE NULL END)...

Using the calendar table you could first aggregate the values.

In a second step, use the CrossTab approach to pivot the result. For details how the CrossTab concept works, see the...

Whatever you define as a "Lane", the best way I can think of is using a calendar table.

I recommend you google for the term "SQL Server calendar table".

Then modify the...

How did you check indexes and how did you arrive at the conclusion "all are ok"?

Another option would be to build the UNION ALL cte based on telephoneregion1 and telephoneregion2...

If the number of columns is unknown, I would use the DynamicCrossTab approach instead of PIVOT.

Please see the two related articles referenced in my signature.

Since you most probably need to...

You might want to start with the Stairway to SSRS[/url] series.

bitbucket-25253 (12/19/2011)

---

LutzM Posted Today @ 9:07 AM

Hmmm.... interesting....

Based on the (almost public available) age of the two fellows you're somewhat between 14 and 16 years old. Hard to believe that...

Dev (12/19/2011)

---

L' Eomot Inversé (12/18/2011)

---

Revenant (12/17/2011)

---

I have started on 2 September 1970, on an IBM 360/40 installation that was pride of the town: 128k of memory, 8 tape...

Revenant (12/17/2011)

---

...

That's not how it works. I do not want to swamp you with my conclusions -- and I have been around like 30+ years --; but if you...

L' Eomot Inversé (12/17/2011)

---

LutzM (12/17/2011)

---

Stefan Krzywicki (12/16/2011)

---

In addition to many of the faults I already knew...