Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,171 through 43,185 (of 59,063 total)

RE: How to chage IDENTITY Column seed

You're welcome. Thanks for the response.
--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)

June 29, 2009 at 5:20 am

#1016719
RE: Split string using XML

The article is well written and my hat is off to the author for that. I have to agree with the others, though... using XML to split delimited data...
--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)

June 28, 2009 at 7:47 pm

#1016576
RE: How to transpose from Row to Columns with out using Pivot

lmu92 (6/28/2009)
Paul White (6/28/2009)
lmu92 (6/28/2009)
Paul White (6/27/2009)
Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods. ...
Paul
But how about the method 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)

June 28, 2009 at 8:40 am

#1016533
RE: How to transpose from Row to Columns with out using Pivot

Paul White (6/28/2009)
Jeff, could you let me have the number of your handrail-installation team please? 😀
PIVOT can be used with dynamic SQL, just the same as the CASE...SUM idea.
Heh......
--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)

June 28, 2009 at 8:31 am

#1016531
RE: printing 1 to 100 in SQL Server as a batch....

Paul White (6/28/2009)
Guys,
Does it really matter that much what was meant by the word 'correct'?
Taking the poor guy to task over semantics seems unfair.
Paul
Nah... not the word "correct"... I want...
--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)

June 28, 2009 at 8:18 am

#1016528
RE: get real!

At least the correct answer wasn't "close" to all the other answers because none of the answers are correct in 2k.
1.2345679E+9
Before you start beating the "latest version" drum on 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)

June 27, 2009 at 9:47 pm

#1016473
RE: On Error () Logging by Using Event Handlers

Just a quick question... I don't see where the column called "PrcocedureName" in the error log table is either described or used in the article. Is it just an...
--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)

June 27, 2009 at 9:12 pm

#1016470
RE: How to transpose from Row to Columns with out using Pivot

Paul White (6/27/2009)
Clearly, in this case, and with this data distribution, there is nothing to choose between the three methods.
I'll probably stick to using the Cross-Tab code (one method or...
--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)

June 27, 2009 at 8:57 pm

#1016468
RE: User-defined function not recognized

jo stovall (6/25/2009)
Thanks, Jeff.
When I ran your SQL statement, I got this:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.Objects'.
Privileges, 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)

June 27, 2009 at 8:37 pm

#1016465
RE: printing 1 to 100 in SQL Server as a batch....

Lynn Pettis (6/26/2009)
Sinshith S Anand (6/26/2009)
Hello Friends,
I made necessary changes on the program. Now it will work smoothly..I will be careful from next time
Okay, this is 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)

June 27, 2009 at 8:29 pm

#1016464
RE: Formatting data from two rows

NewBie (6/23/2009)
Jeff Moden (6/23/2009)
Will there ever be 3 rows?
No, only 2 rows. But why do you ask ?
Just to be sure. Problems like this usually fail sometime 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)

June 27, 2009 at 8:23 pm

#1016462
RE: Converting non-clustered index to clustered index

Eswin (6/24/2009)
Hi jeff,
The story is i have non-clustered PK .
I want to make this non-clustered PK to clustered PK in sql server 2000 because it will improve performance i guess.
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)

June 27, 2009 at 8:12 pm

#1016461
RE: converting lowercase to uppercase

sqlguru (6/24/2009)
The database is not suppose to format data on the fly, that's not it's job. RDMS are very weak at computational stuff like formatting. This should be handled in...
--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)

June 27, 2009 at 7:35 pm

#1016458
RE: Are the posted questions getting worse?

Florian Reischl (6/27/2009)
I read your really good article and did my own tests. If multi-aggregated results are required the cross-tab solution is much faster than pivot. But in case of...
--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)

June 27, 2009 at 7:16 pm

#1016455
RE: pivot problem

Thanks for the feedback, Vick. If you want that to fly, convert it to a bit of pre-aggregation. Like this...
[font="Courier New"];WITH
ctePreAgg AS
(
SELECT BatchID, ParamName, MIN(ParamValue) AS MinParamValue
   FROM #Foo
  GROUP BY BatchID, ParamName
)
SELECT BatchID,
        MIN(CASE WHEN ParamName = 'outfolder' THEN ParamValue ELSE NULL END) AS OutFileLocation
        MIN(CASE WHEN ParamName = 'outfile'   THEN ParamValue ELSE NULL END) AS OutFileName
   FROM ctePreAgg
  GROUP BY BatchID[/font]
Put an index on BatchID, ParamName with an...
--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)

June 26, 2009 at 10:22 pm

#1016350

Viewing 15 posts - 43,171 through 43,185 (of 59,063 total)