DavidDroog (7/23/2015)

---

Hi All

Surprised this thread was still going when logged in this morning. ChrisM - I didn't realise people were actually offering to optimise my query, but if that is...

DavidDroog (7/22/2015)

---

Hi Guys

thanks for the replies.

...

@chrism-2 - Yes, it does look complicated and there may be a couple of unecessary joins, but it works fine without the addition of the...

The original query appears to be "For each client, get all the products and all their colours". The other tables in the query could filter the output by geography but...

Sean Lange (7/16/2015)

---

SQLRNNR (7/16/2015)

---

Sean Lange (7/16/2015)

---

Another thing to do in Seattle...of course the NW is known for having lots of microbreweries but what often goes unmentioned is that many of...

Or rather this:

-- This table holds account positions data that are appended to multiple times a day

-- what is the efficient way to retrieve the first set of positions...

-- Determine the most recent load_id, use it as a filter.

-- It will be about as fast as it can get without adding

-- additional indexes because load_id is the leading...

Instead of updating the temp table, why not calculate the value when you populate it, like this:

SUM(DayCount) OVER(PARTITION BY Loss_State)

TomThomson (7/13/2015)

---

Lynn Pettis (7/13/2015)

---

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running to...

jghali (7/13/2015)

---

Thanks for your response...

1. the execution plans of the Row_number for:

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY [UPC], [LocGroup] ORDER BY PriceLvl) FROM #Master_TAB

SELECT *, rn =...

Firstly, ROW_NUMBER() doesn't necessarily invoke a sort. Compare the execution plan of these two queries:

SELECT *, rn = ROW_NUMBER() OVER(PARTITION BY [UPC], [LocGroup] ORDER BY PriceLvl) FROM #Master_TAB

SELECT *, rn...

-- The outer query makes little sense, it only adds duplicate rows to a set which you're eliminating rows from

SELECT MT.A3+MT.A4 AS A34, MT.A3

-- ,M.*

FROM Master_TAB M

JOIN...

HerryMarkowitz (7/10/2015)

---

ChrisM@Work (7/10/2015)

---

HerryMarkowitz (7/10/2015)

---

I want INVENNO 101, 102, 103, 104, 105, 106, 107.

But I dont want to see 102, 103, 104, 105, 106 lines in the sql code.

I want a...

HerryMarkowitz (7/10/2015)

---

I want INVENNO 101, 102, 103, 104, 105, 106, 107.

But I dont want to see 102, 103, 104, 105, 106 lines in the sql code.

I want a loop code...

The code I...

HerryMarkowitz (7/10/2015)

---

Hi again,

Thanks for the codes.

But your codes are not what I want.

Maybe I am not able to explain my needs because I am very new with SQL coding.

Let me...