Sigh, so close!

Tested, Jeff's technique and it works great. Had to make some modifications to the code to work with my data but it wasn't too bad. Was...

Ok, Jeff...you're starting to make a believer out of me. Hierarchyid's are all nice and dandy until you go ahead and move a node. Sure there is a...

Lynn Pettis (3/15/2016)

---

yb751 (3/15/2016)

---

That's definitely the way to go if that's an option. However, I've...

That's definitely the way to go if that's an option. However, I've never seen a...

Jeff Moden (3/15/2016)

---

yb751 (3/15/2016)

---

Interesting stuff Jeff...I've bookmarked those articles. A little more than I can handle...

Jason-299789 (3/15/2016)

---

@yb751,

I appreciate that but you write a query in one instance to do specific job then someone comes up with a bright idea of expanding the grain, so you...

Steve Jones - SSC Editor (3/15/2016)

---

JustMarie (3/15/2016)

---

Steve Jones - SSC Editor (3/15/2016)

---

I'm sad today

One bit of advice. Work with your body shop to make sure that the repairs come under...

Because it some cases it was redundant. We didn't have enough...

Jason-299789 (3/15/2016)

---

@yb751

The NULL will only be eradicated if there is a row with a non-Null value, in the same column.

See the code below, when aggregating on Account.

DECLARE @myTable TABLE...

You caught that too...makes you wonder if people are using other people's accounts. But why?

GilaMonster (3/15/2016)

---

You don't need ISNULL.

Why are you grouping by the things you want to add? Group By should be what you want the totals summed by. If you just want...

lkennedy76 (3/15/2016)

---

okay guys, I am stuck. I have two columns that I need to add and make one total for a report. there are null values so I have to...

hoseam (3/15/2016)

---

DECLARE @End_Date DATE

,@The_Date ...

Interesting stuff Jeff...I've bookmarked those articles. A little more than I can handle before I've finished...

Phil Parkin (3/14/2016)

---

yb751 (3/14/2016)

---

I started working with the hierarchyID data type. So far it's been pretty great working with the built-in functions rather than having to use recursive CTE's....