Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,071 through 38,085 (of 59,072 total)

RE: how can i do this convert

cfradenburg (4/6/2010)
Jeff, thanks for catching that. Any particular reason that you switched from charindex to patindex? Charindex can handle multiple characters and I'm assuming there's a reason you...
--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 5, 2010 at 8:10 am

#1176791
RE: how can i do this convert

Bhuvnesh (4/6/2010)
Jeff Moden (4/5/2010)
Bhuvnesh,
I'm not taking a jab at you... I have to ask, though... how often do you find it necessary to split something longer than 8K bytes? ...
--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 5, 2010 at 7:57 am

#1176790
RE: Auto Increment Alphabet

Thanks for the feedback, Ankit...
There's a fair bit of complexity to using a base 26 "numbering" system like this even if you don't take into account all the swear words...
--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 5, 2010 at 7:21 am

#1176789
RE: Want to Calculate Business Working hours

Ken Champion (12/11/2009)
This is my first experience with a tally table. I modified your solution to calculate number of business days given the start datetime and end datetime, 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 4, 2010 at 9:44 pm

#1176776
RE: Create date range with only one date using previous record's END DATE

{edit} Never mind...
--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 4, 2010 at 4:01 pm

#1176751
RE: Changing dates to Integers

It's real simple.... a thousand professional opinions aren't worth a hoot. A single well written test will tell all. Have the BI "experts" prove their hypothesis using 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)

June 4, 2010 at 3:53 pm

#1176743
RE: Obtain the date of datetime field

Actually, the op said nothing about a SELECT and you don't know how your answer will be used.
If it's for a SELECT to return a result set to the 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)

June 4, 2010 at 3:39 pm

#1176737
RE: stored procedure search condtion between two dates

rjohal-500813 (6/2/2010)
SELECT something FROM somewhere WHERE whenever
BETWEEN Now AND Then
Disclaimer: I am not at my SQL machine, so the syntax may not be perfect and I haven't been able to fully test...
--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 4, 2010 at 2:58 pm

#1176727
RE: How to replace the cursor

cfrestrepo (6/4/2010)
I found a better solution in SqlServer 2008
Ummm... it depends on what you mean by "better". First, that solution will work on all versions of SQL Server (observing...
--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 4, 2010 at 2:51 pm

#1176725
RE: How to replace the cursor

Nagesh S-432384 (6/3/2010)
Nagesh S-432384 (6/3/2010)
Jeff Moden (6/2/2010)
Very cool feedback, Nagesh. Thank you for taking the time.
one more late response Jeff 🙂 I am in IST (in India) so 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)

June 4, 2010 at 2:45 pm

#1176724
RE: Two Temp Tables within a Proc

Very cool. Thanks for the feedback, Dan.
--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 4, 2010 at 2:43 pm

#1176723
RE: Obtain the date of datetime field

Oleg Netchaev (6/2/2010)
I have read the blog by Lynn Pettis in the past, the conversions are definitely very useful. The convert function is simple enough though and should be OK...
--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 3, 2010 at 3:00 pm

#1176217
RE: Store calculations in a table or use computed columns?

As Yogi Bera used to say, "When you come to a fork in the road, take it.". If you can suscessfully create a computed column, try to make 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)

June 3, 2010 at 2:45 pm

#1176207
RE: Two Temp Tables within a Proc

Dan Fran (6/3/2010)
Thanks for the reply and willingness to help John. See my previous post before yours. All is working fine now. Once again, thanks.
I'll "third" what...
--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 3, 2010 at 2:41 pm

#1176203
RE: How to combine records in same table (Flatten a table) ?

BIMind (6/3/2010)
berry, no your assumption is wrong
table1 doesnt have 3 fixed offer names..it can have N offers..
my source table is table1
my dest table is table2
its complicated because i only start...
--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 3, 2010 at 2:26 pm

#1176190

Viewing 15 posts - 38,071 through 38,085 (of 59,072 total)