skilly2 (3/26/2015)

---

This worked perfectly! I'm still trying to wrap my head around it though. I understand what the Over (Partition statement does normally, but I've never used the...

SQLRNNR (3/26/2015)

---

dwain.c (3/26/2015)

---

ChrisM@Work (3/26/2015)

---

Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional query i.e. the IF as...

Solomon Rutzky (3/26/2015)

---

peter-757102 (3/26/2015)

---

Gary Harding (3/26/2015)

---

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on...

ChrisM@Work (3/26/2015)

---

Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional query i.e. the IF as well as...

tfendt (3/26/2015)

---

This works :). One thing I forgot to mention however is the fees are dynamic and not just limited to BFee and Holding, is it possible to modify it...

-- Whilst I'm a consultant named Jack

-- I swear that I'll never be back

-- Removing this code

-- Causes server overload

-- Despite you're thinking its a hack.

See what I mean?

The worst comments use the words whilst, whence, betwixt and amongst or any of their related British-isms. 😛

Unless they're used consistently of course.

Gary Varga (3/26/2015)

---

dwain.c (3/25/2015)

---

...I beginning to think that when I wrote this article (based on a quotation from Jeff):

Make it Work, Make it Fast, Make it Pretty[/url]

Maybe I should have...

Hehe. I'm sure all will forgive you Eirikur!

Better to have stumped you than for you to find my code-craft lacking.

Jeff Moden (3/25/2015)

---

dwain.c (3/25/2015)

---

I hate it when you ask questions like...

This may be a little cleaner:

WITH EffectiveDates AS

(

SELECT PriceEffectiveDate, RCID, TID, PCD

FROM #BasePrice

UNION

SELECT EffectiveDate,...

I'd guess there's probably a better way to do this (certainly true in SQL 2012), but for now this is the best I can come up with.

SELECT EffectiveDate, RCID, TID,...

Man, this looks like deja vu all over again!

http://www.sqlservercentral.com/Forums/Topic1671044-3412-1.aspx?Update=1%5D

Never let it be said I can't learn from the master (that being Itzik Ben-Gan):

WITH RcdItems AS

(

SELECT *,

...

Jeff Moden (3/25/2015)

---

LightVader (3/25/2015)

---

ChrisM@Work (3/25/2015)

---

Jeff Moden (3/24/2015)

---

Eirikur Eiriksson (3/24/2015)

---

Wayne West (3/23/2015)

---

Jeff Moden (3/22/2015)

---

Steve Jones - SSC Editor (3/16/2015)

---

Eirikur Eiriksson (3/13/2015)

---

Digressing slightly, how would the threadizens describe the optimal code comments?...

Sean Lange (3/25/2015)

---

Speak and he shall appear. The OP...