Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,361 through 30,375 (of 59,101 total)

RE: Recursive CTE for Item supersession question

It actually doesn't matter whether you called it a "standard" or not, you're advocating and even recommending the use of a date/time format not specifically covered by ISO 8601. Yet,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 9:06 pm

#1473828
RE: Finding top parent using CTE

Mark Fitzgerald-331224 (4/15/2012)
I have produced other code to examine tree structures for loops that do indicate the existence of closed loops.
Any chance of us seeing such code as it would...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 4:40 pm

#1473817
RE: Finding top parent using CTE

Apologies. I almost forgot. Here's what I used to build the test data.
--===== Conditionaly drop the test table so we can do reruns more easily
...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 3:57 pm

#1473813
RE: Finding top parent using CTE

Never mind. I don't need the DDL or the indexes or anything. I built a million row hierarchical test table to match what was originally posted. Performance...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 3:48 pm

#1473811
RE: Recursive CTE for Item supersession question

CELKO (4/15/2012)
Why was everyone so hung up on the MySQL month names? Wait until they learn about the rest of the ISO-8601 date formats!
It's real simple, Joe. You...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 3:29 pm

#1473806
RE: Recursive CTE for Item supersession question

CELKO (4/14/2012)
Unfortunately, Mr. Celko, this isn't MySQL. This is MS SQL Server and it doesn't have the same capabilities as MySQL or Oracle.
You do know that T-SQL now has a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 2:33 pm

#1473794
RE: Finding top parent using CTE

F.L (4/15/2012)
Hello,
I´m trying to use CTE to find the very top parent within a table without any NULLs
My test table seems to work but when applying the logic on a...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 2:14 pm

#1473786
RE: Finding top parent using CTE

Mark Fitzgerald-331224 (4/15/2012)
In the sample data given the recursive part ends when the selected parent (either 10 or 11) is not found. The chosen sample data does not have...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 15, 2012 at 1:47 pm

#1473773
RE: Recursive CTE for Item supersession question

So where did you go??? I checked your profile for additional posts and didn't find one.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 14, 2012 at 6:59 pm

#1473690
RE: Are the posted questions getting worse?

capn.hector (4/13/2012)
ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more out there)...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 13, 2012 at 2:28 pm

#1473505
RE: Sequences in SQL Server 2012

stephanie.sullivan (4/13/2012)
I was more thinking as a way of producing the tally table itself - Jeff uses an identity and cross joins sys columns. This method may or may...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 13, 2012 at 12:12 pm

#1473407
RE: hierarchial query in sql server 2005

sukruti.patel (4/12/2012)
What is the performance with CTE/Hierarcy when it comes to more than Millions of records getting inserted into table?
Provided that the parent/child information is precalculated and included in such...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2012 at 5:12 pm

#1472997
RE: Query Performance - Table Temporary

TheSQLGuru (4/12/2012)
I can probably count on my fingers and toes how many times (in 15+ years of consulting on SQL Server) how many times an index on a temporary table...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 12, 2012 at 5:04 pm

#1472996
RE: Are the posted questions getting worse?

Lynn Pettis (4/11/2012)
Lynn Pettis (4/11/2012)
Not sure but I think this individual, xenophilia, should change their name to xenosqlia.
Please, someone tell me why, just why do I keep helping someone who...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2012 at 3:37 pm

#1472281
RE: Are the posted questions getting worse?

Sean Lange (4/11/2012)
What is wrong with people today? So many stupid posts with little to no information or clarity. Did I miss the memo about today being "Leave your brain...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

April 11, 2012 at 2:47 pm

#1472239

Viewing 15 posts - 30,361 through 30,375 (of 59,101 total)