Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,401 through 38,415 (of 59,098 total)

RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

mahbub422 (5/12/2010)
Dear Paul,
Your technique is better. So, I am interested to use your technique. Peter also suggested me to follow your method. I already inserted around 1200 data in database...
--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)

May 15, 2010 at 5:21 pm

#1167965
RE: How to insert these dates in database

WayneS (5/15/2010)
Instead of passing all those dates to the database to be added in one at a time, why don't you make a stored procedure and pass just the starting...
--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)

May 15, 2010 at 11:51 am

#1167946
RE: How to count left side nodes and right side nodes for managing a chain link(binary tree)application

Peter Brinkhaus (3/20/2010)
Unfortunately we don't have a realistic testset (and I'm too lazy now to generate one), but I'm almost certain that Paul's solution outperforms my solution by a factor...
--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)

May 15, 2010 at 11:41 am

#1167945
RE: Need a date between what MIN and MAX returns

ninel (5/14/2010)
Normally I would use MIN function to pick up the earliest date I need processed. Lately i've been finding at least one date is out of the norm....
--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)

May 15, 2010 at 11:00 am

#1167941
RE: Need a date between what MIN and MAX returns

vijay.s (5/15/2010)
WHERE MIN(GETDATE()) = GETDATE()--So its a next day date from your minimum date
I Hope this what you wanted! If you want to a batter solution then try to post...
--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)

May 15, 2010 at 10:56 am

#1167940
RE: Difference between Inline view and Derived table

Paul White NZ (5/15/2010)
tarun.jaggi (5/14/2010)
Can anyone of you please tell me the difference between Inline view and Derived table?
In general, the way the terminology is commonly used, I would say...
--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)

May 15, 2010 at 10:54 am

#1167939
RE: CTE performance

kazim.raza (5/14/2010)
Certainly not; or else; what will our friend do 😛
By brainstorming I meant just to take a high level review or opinion...
~ Kazim Raza
You should know me by now......
--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)

May 15, 2010 at 10:20 am

#1167937
RE: SQL to manipulate rows of data

krenshau (5/14/2010)
Jeff, I have been thinking about whether or not to reply to your post. First, thank you for informing me of the rules. However, I find it interesting that...
--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)

May 15, 2010 at 10:11 am

#1167936
RE: More, More, More

GilaMonster (5/14/2010)
What bugs me is when people resurrect an old thread to post an answer that's less accurate/useful than an answer already posted in the thread.
Heh... absolutely agreed. I...
--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)

May 15, 2010 at 7:35 am

#1167918
RE: Adding Header and Trailer

Paul White NZ (5/15/2010)
I've had to do this a number of times from within SQL Server. The neatest way I have found is to create a T-SQL object (procedure...
--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)

May 15, 2010 at 7:29 am

#1167917
RE: Comparing two rows in one table for changes in column

BWAA-HAAA!!! Thanks for the feedback, Dobermann. I do have one more trick up my sleeve if all else fails. I've been trying to keep this in the...
--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)

May 14, 2010 at 9:46 pm

#1167863
RE: Sample database design, development, test and deployment for an online student class.

Steve Jones - Editor (5/14/2010)
If you know a bit, post what you know, or what you'd do, and then what you are confused about. As Gail mentioned, we don't do...
--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)

May 14, 2010 at 9:39 pm

#1167862
RE: Sample database design, development, test and deployment for an online student class.

Irfan-358189 (5/14/2010)
I am sorry If i have asked more than i should.I just want a step by step documentation to how to design and develop database.I know i will 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)

May 14, 2010 at 9:27 pm

#1167861
RE: Find PreviousChange of date

jez.lisle (5/14/2010)
I have a simple table of which is an extract below, I have a query that will order each job by row number , what I want to do...
--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)

May 14, 2010 at 9:06 pm

#1167860
RE: Author Guidelines

Here are a couple of more tips about things that either I use or that aggravate the heck out of me...
1. While it’s ok to write articles about things...
--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)

May 14, 2010 at 8:57 pm

#1167859

Viewing 15 posts - 38,401 through 38,415 (of 59,098 total)