Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,381 through 37,395 (of 59,098 total)

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
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

joel.weiss 70857 (8/6/2010)
I want dynamic pivots, i,e., pivot a table without knowing what exists in the pivot data. Nothing short will satisfy me. It seems like a religious...
--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:25 am

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

roger_os (8/6/2010)
Thanks for the article Jeff.
You bet. Thanks for stopping by.
--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 5:38 am

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

TheSQLGuru (8/6/2010)
I soooo prefer the CASE syntax to PIVOT! 🙂
I did learn something new, which honestly doesn't happen all that often for me when it comes to...
--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 4:39 am

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

Gillbert (8/6/2010)
Dear All,
This all [HARD coded] like year or month whatever
in my situations, i don't want to [HARD Coded] my pivt value,
how to build the qry, if anybody's...
--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 4:30 am

#1203363

Viewing 15 posts - 37,381 through 37,395 (of 59,098 total)