Viewing 15 posts - 361 through 375 (of 627 total)
Jeff Moden (3/17/2016)
yb751 (3/17/2016)
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...
March 18, 2016 at 1:27 pm
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...
March 17, 2016 at 1:32 pm
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...
March 17, 2016 at 8:38 am
Lynn Pettis (3/15/2016)
yb751 (3/15/2016)
Lynn Pettis (3/15/2016)
Or paid cash to avoid paying 20% interest on a loan. 😀
That's definitely the way to go if that's an option. However, I've...
March 15, 2016 at 1:56 pm
Lynn Pettis (3/15/2016)
Or paid cash to avoid paying 20% interest on a loan. 😀
That's definitely the way to go if that's an option. However, I've never seen a...
March 15, 2016 at 1:28 pm
Jeff Moden (3/15/2016)
yb751 (3/15/2016)
Jeff Moden (3/14/2016)
Shifting gears a bit......Consider the possibility of not using HierarchyID at all.
Interesting stuff Jeff...I've bookmarked those articles. A little more than I can handle...
March 15, 2016 at 12:03 pm
Jason-299789 (3/15/2016)
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...
March 15, 2016 at 11:50 am
Steve Jones - SSC Editor (3/15/2016)
JustMarie (3/15/2016)
Steve Jones - SSC Editor (3/15/2016)
One bit of advice. Work with your body shop to make sure that the repairs come under...
March 15, 2016 at 11:45 am
lkennedy76 (3/15/2016)
I have null values that I need to remove, ISNULL does that, why would I not use it?
Because it some cases it was redundant. We didn't have enough...
March 15, 2016 at 8:59 am
Jason-299789 (3/15/2016)
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...
March 15, 2016 at 8:35 am
GilaMonster (3/15/2016)
A sig that claims an MCSA and can't use SUM?
You caught that too...makes you wonder if people are using other people's accounts. But why?
March 15, 2016 at 8:24 am
GilaMonster (3/15/2016)
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...
March 15, 2016 at 8:20 am
lkennedy76 (3/15/2016)
March 15, 2016 at 8:14 am
hoseam (3/15/2016)
DECLARE @End_Date DATE
,@The_Date ...
March 15, 2016 at 7:54 am
Jeff Moden (3/14/2016)
Shifting gears a bit......Consider the possibility of not using HierarchyID at all.
Interesting stuff Jeff...I've bookmarked those articles. A little more than I can handle before I've finished...
March 15, 2016 at 7:17 am
Viewing 15 posts - 361 through 375 (of 627 total)