Viewing 15 posts - 32,251 through 32,265 (of 59,102 total)
bitbucket-25253 (10/17/2011)
Thanks for all you have done to teach myself...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 18, 2011 at 8:22 am
WayneS (10/17/2011)
Anyone have an idea if this post http://www.sqlservercentral.com/Forums/FindPost1191243.aspx is spam? (Afraid to click the link that is in that linked post...)
It's ok... he's been here before and has apparently...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 10:40 pm
Alan,
This sounds like a mostly static tree. Can you give an estimate on how often the tree may suffer the addition, deletion, or modifcation of at least 1 node...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 10:21 pm
bitbucket-25253 (10/17/2011)
Thanks for all you have done to teach myself...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 10:04 pm
Ninja's_RGR'us (10/17/2011)
Jeff Moden (10/17/2011)
I certainly missed this one. Thanks folks! I really appreciate the great thoughts. :blush:Let's put it in the duplicate category ;-).
Let's not. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 10:02 pm
The award ceremony in Seattle has come and gone. It was absolutely awesome especially since I got to put a check-mark next to some folks' names on my "bucket...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 6:32 pm
I certainly missed this one. Thanks folks! I really appreciate the great thoughts. :blush:
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 6:27 pm
Dev @ +91 973 913 6683 (10/17/2011)
since assignment of tasks frequently requires that "How" questions are frequently asked by the assignees.
If you are getting too many 'How' questions,...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 4:23 am
Alan Stanley (10/17/2011)
The first CTE is being populated bottom up. i.e. we are passing in a list of branch nodes and getting back each node to the root.
THAT would be...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 17, 2011 at 4:19 am
The way I solved this problem for my group was to simply use QUOTENAME(columnname, '"') and make sure that I used '"' as the text qualifier.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 6:03 pm
noyb 30173 (10/16/2011)
Next I will...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 5:50 pm
battery_acid_h (10/14/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 5:28 pm
2 way street here, AAKR. Please answer Gail's questions so we can all learn something new. Thanks.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 5:05 pm
Nah... not to worry. Sometimes it's hard to put questions/requirements together. Now we know what a BA goes through. 😀 Glad I could help.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 5:01 pm
In that case, how's this look?
WITH
cteUnPvt AS
( --=== Unpivot the data so we can work with it
SELECT t.affil,
t.Charqtr, ...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2011 at 4:58 pm
Viewing 15 posts - 32,251 through 32,265 (of 59,102 total)