Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,636 through 46,650 (of 59,095 total)

RE: Compute Clause????

Dang... I gotta get new glasses or stronger coffee. I mean really... I didn't even see the ops first post last night, only the short one I quoted 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)

December 13, 2008 at 8:21 am

#912045
RE: Compute Clause????

xsaycocie (12/12/2008)
Yep did that with a group by but the result is .01 off
The above return the following:
TT
---
3.05
7.64
2.55
25.45 and the compute total of 38.69
When I group by... the total is...
--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)

December 12, 2008 at 10:24 pm

#911999
RE: Guest Editorial: On writing SQL

I'm acutely aware that there are a number of tricks to being a highly productive SQL Programmer, and I cringe at the thought that I only know a few 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)

December 12, 2008 at 10:20 pm

#911997
RE: Guest Editorial: On writing SQL

Heh... I've found that helical fletching makes a high velocity pork chop sound really cool as well as enhancing the flight path... haven't gotten into the bowyer mode of building...
--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)

December 12, 2008 at 9:17 pm

#911993
RE: How to remove blank spaces

Cool... thanks for posting what you ended up 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)

December 12, 2008 at 8:55 pm

#911991
RE: Need help using SSIS to transform a flat file into SQL table

Rob Millerd (12/10/2008)
Can someone discribe how I would accomplish this in SSIS?
Heh... no... and I'm not trying to be a smart guy here. The reason why my answer is...
--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)

December 12, 2008 at 8:44 pm

#911990
RE: Columns (header) and setting something off

You bet... thank you for the feedback. 🙂
--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)

December 12, 2008 at 8:23 pm

#911989
RE: Selecting numbers up to the first non-numeric char from a string

engintoksoz (12/12/2008)
Well done Jeff. Thanks.
Thanks for the feedback, engintoksoz. 🙂 If you have any doubts about any of this, please don't hesitate to ask... I'll see if I can...
--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)

December 12, 2008 at 8:20 pm

#911988
RE: Updating a Column Using a Recursive Definition

bkmooney (12/12/2008)
Jeff,
I'm attaching the file with the formatted test data. It should generate about 150 rows of data for you. And because it makes things more interesting...
--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)

December 12, 2008 at 7:58 pm

#911987
RE: Updating a Column Using a Recursive Definition

bkmooney (12/12/2008)
Jeff,
I'm attaching the file with the formatted test data. It should generate about 150 rows of data for you. And because it makes things more interesting...
--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)

December 12, 2008 at 6:54 pm

#911983
RE: Updating a Column Using a Recursive Definition

smunson (12/12/2008)
Looks like Peso nailed the concept for using the "quirky update" to get at the data,...
Ya know what? I missed Peso's post... that's just about where I'm going...
--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)

December 12, 2008 at 6:36 pm

#911981
RE: Are the posted questions getting worse?

Easy big boy... these are not the droids you 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)

December 12, 2008 at 6:25 pm

#911978
RE: Outsourcing is the best idea ???

Heh... told ya I'd be pretty much alone in what I said...
Perhaps some clarification on what I mean by "outsourcing" is necessary... buying and having someone install/interface a well known...
--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)

December 12, 2008 at 6:23 pm

#911977
RE: Outsourcing is the best idea ???

I guess I'll be the only one with a rock solid opinion on this one...
Outsourcing is absolutely the worst idea at all times. The people writing code to solve...
--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)

December 12, 2008 at 11:36 am

#911842
RE: script to get all tables an sizes

rbarryyoung (12/12/2008)
This should do it. You can use it either as a query or a View: http://www.sqlservercentral.com/scripts/tables/62545/
Heh... dammit... now I'll never get the answer to my question...
--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)

December 12, 2008 at 11:24 am

#911831

Viewing 15 posts - 46,636 through 46,650 (of 59,095 total)