I'm thinking a model rocket motor embedded in a potato specially carved for...

Brandie Tarvin (9/24/2013)

---

wolfkillj (9/20/2013)

---

In just a quick review of your DDL, I didn't see an index that would cover this query. FIDX_StagingRecID2 comes close but it doesn't include the Extract_RI...

Ed Wagner (9/24/2013)

---

<snipped>

I had tossed around the idea in my head about a barrel that's open in the rear, but that would probably require a self-propelled potato, which I've personally...

Brandie Tarvin (9/24/2013)

---

GAH. I keep forgetting that I can't create an index on the Extract column because the column is too big.

I guess I'll have to live with the Key...

GilaMonster (9/23/2013)

---

And now that the paperwork has been signed....

November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing on...

LinksUp (9/23/2013)

---

wolfkillj (9/23/2013)

---

And duh, of course you can see the number of executions of a node in an execution plan displayed as Number of Executions in the Properties that pop...

And duh, of course you can see the number of executions of a node in an execution plan displayed as Number of Executions in the Properties that pop up when...

LinksUp (9/23/2013)

---

Your code is indeed more efficient!

I just ran all 3 queries and checked the Execution plan on each one and I am only seeing 2 Table Scans on...

LinksUp (9/22/2013)

---

perireddy.arikatla (9/22/2013)

---

When i Run the query without giving party_code in where clause

i.e

SELECT party_code, sum(inst_amt) as total_insts,

(Select Sum(paid_amt) as total_paid

...

Charlottecb (9/20/2013)

---

Hi Wolfkillj,

Many thanks to you also for taking the time to respond to my question. Unfortunately it doesn't seem to give me the correct result - all 3 customers...

RedBirdOBX (9/19/2013)

---

Thanks Mark. I think my basic design was flawed too. I moved the FK in the Accounts Table. The Account belongs to the customer. Not...

Jan Van der Eecken (9/20/2013)

---

wolfkillj (9/20/2013)

---

Don't know, but the Congressional Record would include both the...

Suspecting the CTE with an inner join and row numbering would be somewhat costly, I compared it against this:

SELECT c.customername, o.ordernumber, o.orderdate

FROM customer c

CROSS APPLY (SELECT TOP(1) ox.ordernumber, ox.orderdate FROM...

Don't know, but the Congressional Record would include both the recipes and any statements made...

Jan Van der Eecken (9/20/2013)

---

Sean Lange (9/20/2013)

---

Jan Van der Eecken (9/20/2013)

---

I don't think I'm the lone non-US citizen who doesn't quite understand what the Filibuster is...