Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,671 through 44,685 (of 59,095 total)

RE: How do I select a specific entry from a select top nn statement

Heh... ya just gotta know what the next question on this will 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)

March 10, 2009 at 8:28 pm

#957223
RE: custom sequence generator

LoveSQL (3/10/2009)
Hi,
Can some one help me writing the following query?
Update the Seq numbers in the table below. Seq numbers must be ordered by their CreateDate and reset 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)

March 10, 2009 at 8:24 pm

#957221
RE: how to get 2 didgit year instead of 4 digit year from Source file

asita (3/10/2009)
Hello GSquared,
i applied SUBSTRING([DateString], 1, 6) + SUBSTRING([DateString], 9, 2) it is working fine, given by Todd
thank you for your valuable response
Best regards
bujji.
That also means that you've learned...
--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)

March 10, 2009 at 8:20 pm

#957219
RE: date format in sql

But, again, and as Flo suggested... SQL Server is NOT the place to do such formatting unless it's for direct output to a file sans any trip through a GUI...
--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)

March 10, 2009 at 8:15 pm

#957218
RE: split date and time from datetime

scorpio_zz19 (3/10/2009)
hi,
i searched how to split the date from datetime data type and i came up with this code(below), the problem is that i dont know where to put it.
...
--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)

March 10, 2009 at 7:52 pm

#957214
RE: Can I make this any faster

I just got done doing one like this a coupe of weeks ago. The problem is the aggregation... you're trying to aggregate in the presence of way too many...
--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)

March 10, 2009 at 7:48 pm

#957212
RE: data type

As Flo implied, variable length columns in SQL Server 2005 are handled quite a bit differently than they were in SQL Server 2000. For example, the following would cause...
--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)

March 10, 2009 at 7:32 pm

#957210
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Chris Morris (3/10/2009)
Wayne (3/9/2009)
Jeff is right. I have to cater for non-trading days other than weekends (which are not included in my sample data) so having a 7 day...
--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)

March 10, 2009 at 4:25 pm

#957138
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

GSquared (3/10/2009)
Jeff Moden (3/10/2009)
You bet, Todd... Thanks for the feedback. Heh... It's amazing how long the myth of Select/Into has managed to survive.
I'll have to look for it, 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)

March 10, 2009 at 2:02 pm

#957067
RE: How to select data in t-sql

Yeah... I agree... the written requirements weren't that clear. The desired return posted along with the attempted code and the existing data was the key.
--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)

March 10, 2009 at 1:59 pm

#957065
RE: BULK INSERT & Text Qualifier

Richard Hurst (3/10/2009)
Alternatively you could just do a find and replace on the original file and get rid of them that way.
I just did because the whole thing was driving...
--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)

March 10, 2009 at 1:56 pm

#957060
RE: Transact-sql for changing a telephone number

Spikemarks (3/10/2009)
Absolutely brilliant but they have now thrown a curved ball and state that some of the phone numbers are from other countries and so the zero needs also 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)

March 10, 2009 at 1:53 pm

#957056
RE: nth WeekDayName of a month

robert.mason (3/10/2009)
Jeff Moden (3/6/2009)
If someone ever starts sending you data with milliseconds, you code will produce incorrect results. If some newbie in a hurry sees your code and decides...
--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)

March 10, 2009 at 1:03 pm

#957023
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

You bet, Todd... Thanks for the feedback. Heh... It's amazing how long the myth of Select/Into has managed to survive.
I'll have to look for it, but I've got 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)

March 10, 2009 at 12:58 pm

#957020
RE: decrypting table contents

Thanks for the kudo, Ross :blush:
I also understand that there are times when the Consultant or other 3rd party wants to protect proprietary code through encryption... that, too, should 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)

March 10, 2009 at 6:27 am

#956716

Viewing 15 posts - 44,671 through 44,685 (of 59,095 total)