Or like this, depending on your data:

SELECT r1.ProductID,

[total number of units to a pallet] = r1.[qty in units] * r2.[units in a case] * r3.[cases to a pallet]

FROM...

Should be quite a bit faster too,...

A couple of suggestions.

/* PQI 09 Measure */

-- second query of two in this section.

-- Existing code

update member_aggregate set PQI09N = discharges

from member_aggregate i

inner join (

select member_id, count(distinct...

The whole thing is dog slow because it's coded naively. Here's a suggestion for you. Post each stored procedure separately. This will encourage folks...

What are you really trying to do? How about that representative...

Put the filter into the JOIN otherwise you will turn it into an INNER JOIN as Ninja shows.

SELECT

c.option_Desc,

c.option_ID,

s.row_ID,

s.User_ID

FROM tbl_codes c

LEFT JOIN tbl_Codes_Select s

ON...

twdavis-893252 (8/10/2011)

---

Will you look at my SQL Statement and give me ideas on how to speed it up and make it leaner. It will be made into a view to...

thompson 44810 (8/10/2011)

---

Paul I understand this is really confusing on my first post.

What I want to do is pull and combine from two different columns in the same database...

Heh...

Try adding COUNT(*) OVER(PARTITION BY Residence_Address) to your first query.

Makes a change from lightning-fast Remi 😉

DROP TABLE #Sample

CREATE TABLE #Sample (Name VARCHAR(10), A INT, B INT, C INT, d INT, E INT)

INSERT INTO #Sample (Name, A, B, C, d, E)

SELECT 'John', 1, 0, 1, 1,...

Jeff Moden (8/9/2011)

---

Thanks, Chris. Always good to hear from you.

I never noticed it before. Your signature line says you're a defender of...

Crackin' good read as always Jeff.

Apologies. Actually it should appear three times:

SELECT LOG_NUMBER,

MAX_EVENT_TIME =...