Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,351 through 37,365 (of 59,072 total)

RE: Rows to Column

antonio.collins (4/3/2008)
unfortunately, this alternative requires a temp table since it doesn't seem CTEs can be nested.
I know it's an old post but what do you mean that CTE's can't be...
--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)

August 8, 2010 at 5:44 am

#1203925
RE: Plzz help me in replacing the cursor with Normal Sql Statements

inampudianil (8/7/2010)
plzz it's very urgent......
Now that you have an answer, the next urgent thing is for you to lookup the UPDATE command in Books Online and teach your self how...
--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)

August 7, 2010 at 7:44 pm

#1203901
RE: Embed the SPROC/script name in the SQL statement

Aw, duuuuude... I've read a couple of the "SQL Janitor" blog entries on that site... there's a whole bunch of things in there based on myth, misconception, or are 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)

August 7, 2010 at 3:06 pm

#1203886
RE: Embed the SPROC/script name in the SQL statement

Peter Samson (8/5/2010)
Write maintainable code - Embed the SPROC/script name in the SQL Statement
Heh... that's nice, Peter, but if you're going to SPAM us with such a thing, 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)

August 7, 2010 at 2:41 pm

#1203882
RE: generate insert statements with data

Dan.Humphries (8/6/2010)
If you want to grab a SQL insert statment you would do something like the following.
Let say you have table A and there are records in in like col1...
--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)

August 7, 2010 at 11:00 am

#1203868
RE: Hirerchy Query Help Required

joshtheflame (8/6/2010)
Victor I tried your procedure its working fine but having issues related to ordering...the ordering of 2nd level items are not the same as it was entered.
Since the ordered...
--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)

August 6, 2010 at 12:36 pm

#1203741
RE: Hirerchy Query Help Required

CELKO (8/6/2010)
Have you ever looked at the Nested Sets model for trees and hierarchies? It is a lot easier than the Oracle "mock pointer chain" traversal or the recursive CTE...
--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)

August 6, 2010 at 12:32 pm

#1203739
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

le_billy (8/6/2010)
Thank you Jeff for your articles on Pivot and cross tabs, your example have given me some new ways to strengthen my code.
Billy
Heh... you're one of the few 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)

August 6, 2010 at 12:12 pm

#1203725
RE: Poll to see how many people set Max Server Memory

Peter Samson (8/6/2010)
On a packaged/COTS app forum, I was surprised to get significant, negative feedback when I suggested setting Max Server Memory. So I'm curious how many people here...
--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)

August 6, 2010 at 11:22 am

#1203700
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

SQL Server Youngling (8/6/2010)
Great article! Well worth the read, and probably future re-reads.
But what are EAV's, NVP's, and CTE's? Definitions of these, or links to other articles...
--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)

August 6, 2010 at 10:42 am

#1203669
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Dennissinned (8/6/2010)
Wow. Really great article. I will never again use pivot. CROSS TAB all the way.
BWAA-HAA!!! I try not to use absolutes like the word "never" but I definitely...
--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)

August 6, 2010 at 9:11 am

#1203598
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Tom Garth (8/6/2010)
Terrific article Jeff, and welcome too. I thought I was being lazy for sticking to the cross tab format for the last few years. I couldn't agree 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)

August 6, 2010 at 9:09 am

#1203595
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

david.c.holley (8/6/2010)
I'd consider myself an advanced beginner. I started playing around with a table valued function mostly to see what would happen. I ended up creating one that uses 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)

August 6, 2010 at 9:06 am

#1203593
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Hey Joel,
Not sure you saw it in my previous post because of the "edit" I did... Check out the following article. While it may not be as intelligent...
--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)

August 6, 2010 at 6:37 am

#1203449
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

joel.weiss 70857 (8/6/2010)
Jeff, you are totally right. Must have been a bad breakfast... my apologies. -Joel
Thanks for that, Joel. Heh... I've had coffee from a soapy cup 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)

August 6, 2010 at 6:31 am

#1203442

Viewing 15 posts - 37,351 through 37,365 (of 59,072 total)