Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,456 through 43,470 (of 59,097 total)

RE: Can you manipulate field names programmatically ?

darryl (6/12/2009)
Greetings once again.
I am working on some sql to be used in a report. I have a transaction table called prtrxp. This table has about 100 fields....
--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 12, 2009 at 9:31 pm

#1008986
RE: Which Rows in Cursor?

Ok... problem solved... you think. A better question is, what are you using a cursor 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)

June 12, 2009 at 9:23 pm

#1008985
RE: Test your problem solving skills!

I believe I'd tell the manager off. It's not his neck if data is inappropriately deleted... it's mine.
I would insist on moving the data to a subdirectory off 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 12, 2009 at 9:22 pm

#1008984
RE: Determining the number of business days between two dates

If all you want is to calculate week days, there's a very short function at the following article.
http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/
If you want work days instead of week days, I suggest...
--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 12, 2009 at 9:06 pm

#1008982
RE: BETWEEN keyword versus =

Paul McCurdy (6/12/2009)
Stupid me - ypu're absolutely right!
value1 >= value2 AND value1 <= value3
was quicker by a few seconds than
value1 BETWEEN value2 AND value3
I know, not my understanding either 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)

June 12, 2009 at 9:00 pm

#1008981
RE: Need to export column headings with stored procedure

siboyd07 (6/10/2009)
I managed to come up with a solution. I don't know if it's the best but it will work. Basically we have an import utility that imported...
--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 12, 2009 at 8:06 pm

#1008975
RE: O(n) , O(n log n), O(n^2)

RBarryYoung (6/10/2009)
Jeff Moden (6/10/2009)
If you strip away all the small stuff that won't impact the result much when the numbers get really big, you end up with O(N²/2). That'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)

June 12, 2009 at 7:49 pm

#1008972
RE: charindex help

Terri (6/10/2009)
Good explanation Jeff. A small point, your solution fails if there is more than 1 space between the 2 words. e.g 'Lincoln Lincoln' has length 16. ...
--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 12, 2009 at 7:36 pm

#1008969
RE: Differences between Unicode Text and ASCII text file

RBarryYoung (6/11/2009)
Jeff Moden (6/10/2009)
RBarryYoung (6/10/2009)
What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.
Any idea if SQL...
--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 12, 2009 at 7:17 pm

#1008967
RE: Mining for Quitters

GSquared (6/11/2009)
So far as I can tell, that's pretty much been the end result of every one of our disagreements. It's just a matter of clarification.
Heh... I concur... but...
--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 12, 2009 at 7:07 pm

#1008965
RE: What SQL Server Sites do you use?

Steve Jones - Editor (6/8/2009)
We have debated about some of the features in Stack Overflow here, especially as they've gained a lot of popularity. I'll post a few threads 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)

June 12, 2009 at 7:03 pm

#1008964
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Barry and Lynn... thanks for the huge compliment. You guys are gonna make me blush. 🙂
--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 12, 2009 at 6:57 pm

#1008963
RE: How to query data on weekly basis

David Jackson (6/11/2009)
Jeff
do we not need the following in the last part of dynamic SQL?
+ 'WHERE (BusinessDate >= ''' + CONVERT(CHAR(10),@FiscalYearStartDate,101) + ''' 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)

June 12, 2009 at 6:49 pm

#1008961
RE: How to query data on weekly basis

David Jackson (6/12/2009)
David Jackson (6/11/2009)
Jeff
do we not need the following in the last part of dynamic SQL?
I have noticed if you do put the date range in the where clause,...
--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 12, 2009 at 6:48 pm

#1008960
RE: How to query data on weekly basis

Greg Edwards (6/10/2009)
Fiscal Calendars can change. And in Jeff's example, what happens next year?
Greg E
Jeff -
I like my chops well done, with some Gates BBQ sauce. :w00t:
Heh... nah... I'll...
--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 12, 2009 at 6:05 pm

#1008954

Viewing 15 posts - 43,456 through 43,470 (of 59,097 total)