Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,711 through 34,725 (of 59,099 total)

RE: Displaying Sorted Hierarchies (SQL Spackle)

Sorry... I double posted by mistake and removed the post from this frame.
--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)

March 10, 2011 at 7:23 am

#1297091
RE: Displaying Sorted Hierarchies (SQL Spackle)

GSquared (3/10/2011)
I've used a variation on this solution for sorting before, and found that it works best if you pad numerical values with leading zeroes to a fixed length, before...
--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)

March 10, 2011 at 7:21 am

#1297089
RE: Displaying Sorted Hierarchies (SQL Spackle)

james-1071007 (3/10/2011)
That doesn't order correctly. You are relaying on the natural data order to provide the correct results.
Try inserting some extra records with lower manager id's and names beginning with...
--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)

March 10, 2011 at 7:19 am

#1297088
RE: Displaying Sorted Hierarchies (SQL Spackle)

Wesley Brown (3/10/2011)
I prefer to use a two column approach to build a tree instead of the single column style that you have to split, it doesn't scale well. For...
--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)

March 10, 2011 at 7:14 am

#1297082
RE: Displaying Sorted Hierarchies (SQL Spackle)

ekoner (3/10/2011)
Really enjoyed this article, it explained the use of the CTE very well. Great work as usual Jeff.
Thanks for the nice compliment, ekoner. I appreciate it.
--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)

March 10, 2011 at 7:09 am

#1297075
RE: Displaying Sorted Hierarchies (SQL Spackle)

Jason-299789 (3/10/2011)
Nice Article Jeff, and having spent a lot of time recently working with them its good to see alternative solutions.
One common problem is people come across is when...
--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)

March 10, 2011 at 7:07 am

#1297074
RE: Displaying Sorted Hierarchies (SQL Spackle)

Michael Meierruth (3/10/2011)
Jeff,
Neat stuff on hierarchies!
One thing that's confusing me is the use of the back slash and how it orders.
Thus in the script below, why do I get two...
--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)

March 10, 2011 at 6:57 am

#1297065
RE: Update table

Hmmm.... I wonder if the batch numbers will always be sequential? If not, the count thing probably won't work.
--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)

March 9, 2011 at 1:42 pm

#1296787
RE: rowcounts different than actual

Not necessarily but, yes, it could be a problem. The only way to know for sure is to look at the execution plan and the code. A GROUP...
--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)

March 9, 2011 at 1:38 pm

#1296785
RE: Complex Query

BeginnerBug (3/9/2011)
thats works like a charm... thanks a lot chris 🙂
For now it works like a charm. What's going to happen when you need to make a modification where...
--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)

March 9, 2011 at 1:32 pm

#1296783
RE: Calculating percentage issue

Jayded (3/9/2011)
Unfortunately it's not enough believe it or not. In this case, a = 52 and b = 10496, so c's percentage will be 0.495%. I'm still only receiving "0"...
--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)

March 9, 2011 at 1:30 pm

#1296779
RE: Parse HL7 message

amns (3/9/2011)
You are right, HL7 is complex.. I will try to parse messages in c# language.
Thanks
Why not just purchase a parser for it?
--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)

March 9, 2011 at 1:19 pm

#1296773
RE: Quality Over Timing

Mark W Johnson (3/9/2011)
krowley (3/9/2011)
When you don't know if a feature will really meet the needs of your users because they don't really know what they want themselves, it just...
--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)

March 9, 2011 at 1:07 pm

#1296767
RE: rowcounts different than actual

sqldba_icon (3/9/2011)
i have a procedure which gives 15 records as output, i also have a trace running simultaneously and i see that "rowcounts" counter for that procedure is 13524....
--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)

March 9, 2011 at 1:02 pm

#1296765
RE: View All Keywords in Full-Text Index

I guess I'll have to take the total lack of response to this thread as a reasonable solid "No, it can't be done". Thanks anyway, folks.
--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)

March 9, 2011 at 11:39 am

#1296689

Viewing 15 posts - 34,711 through 34,725 (of 59,099 total)