Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,346 through 33,360 (of 59,099 total)

RE: XP_cmdshell DIR

Deee -Daah! (7/6/2011)
I originated this thread in 2008. Below is the alternate approach:
1) create a batch file with the following code to list files in folders and subfolders:
@echo off
cd c:\MyFolder
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)

July 7, 2011 at 5:22 am

#1349567
RE: Running total (cummulative Sum)

Chris,
Do you know of a way to use the rCTE to do a running total without the ID's being perfectly sequential?
--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)

July 6, 2011 at 7:40 pm

#1349387
RE: For And ForEach Loops

To go along with Bruce's post, I can't stress enough that a whole lot more CAN be done using set-based code than a lot of folks think. There are...
--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)

July 6, 2011 at 4:56 pm

#1349357
RE: Creating Columns from Rows - Variable Columns - Please Help

itwhiz (7/6/2011)
OK,
So I've had a go with the routine that you suggested, but it's doesn't quite do what I want.
I may not of explained myself very well 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)

July 6, 2011 at 4:46 pm

#1349355
RE: Code Ownership - DBA vs. Developer

Elliott Whitlow (7/6/2011)
Coming back in a little late to the discussion..
Jeff, business users won't take ownership unless you make them.
That's just not true, Elliott. Maybe not 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)

July 6, 2011 at 4:41 pm

#1349354
RE: Mortgage amortization table

There're a few optimizations I might make for performance but it looks real good, Greg.
If you notice, the final entry didn't really get as close to zero as bankers and...
--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)

July 5, 2011 at 7:31 pm

#1348708
RE: SQL Grouping Data

It may make a difference...
Where will the result set of this query be used? In a reporting tool? In a GUI? 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)

July 5, 2011 at 7:05 pm

#1348700
RE: Creating Columns from Rows - Variable Columns - Please Help

Sure... take a look at the following article. And, no... not limited to 10 items. 😉
http://www.sqlservercentral.com/articles/comma+separated+list/71700/
--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)

July 5, 2011 at 6:57 pm

#1348699
RE: Help getting rid of another cursor based query

Tom Rippetoe (7/5/2011)
The 'english' translation of my current proc is:
- populate a cursor with each combination of segment id, begin location, and end location
- for each record in the cursor,...
--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)

July 5, 2011 at 6:52 pm

#1348697
RE: Are the posted questions getting worse?

Koen Verbeeck (7/3/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.
Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again....
--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)

July 5, 2011 at 6:10 pm

#1348693
RE: Are the posted questions getting worse?

Gianluca Sartori (7/4/2011)
Looks like I missed a lot of things during the weekend...
Congratulations to Gail, Jeff and everyone else who got renewed!!!
Thanks, Gianluca.
--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)

July 5, 2011 at 6:09 pm

#1348692
RE: Are the posted questions getting worse?

SwayneBell (7/4/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.
Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again. 🙂
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)

July 5, 2011 at 6:05 pm

#1348689
RE: Are the posted questions getting worse?

SQLRNNR (7/5/2011)
Jeff Moden (7/2/2011)
GilaMonster (7/1/2011)
Thanks everyone. Wasn't actually planning on announcing it here.
Congratulations, Gail. This means that the top two non-employee posters for SSC have been selected again. 🙂
Congrats...
--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)

July 5, 2011 at 5:49 pm

#1348685
RE: First Normal Form

SanDroid (7/5/2011)
To me It reads like two or more people are re-writing/debating the original RDBMS theory material. Trying to fit things Chris Date or Ted Codd wrote about to there...
--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)

July 5, 2011 at 5:44 pm

#1348684
RE: Running Total Issue - ANything New On this Aside from Jeff Modens "Quirky Update"?

Nope. The thing that Paul and Tom came up with is nothing more than an error checking method. It also happens to help guarantee functionality, but there was...
--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)

July 5, 2011 at 5:11 pm

#1348679

Viewing 15 posts - 33,346 through 33,360 (of 59,099 total)