Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,091 through 42,105 (of 59,102 total)

RE: Inserting a word

Chim Kalunta (9/4/2009)
From a performance perspective, you will probably find that a CLR Procedure/Function might out perform a TSql Solution when it comes to heavy duty String manipulation. 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)

September 4, 2009 at 11:47 pm

#1049673
RE: Last Day of any Month

Folks, don't even think of using a user defined function for this. Although it's convenient and you don't have to teach newbies why it works and they don't have...
--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)

September 4, 2009 at 11:37 pm

#1049671
RE: Last Day of any Month

Steve Thompson (9/3/2009)
However, I have one question. This method is contingent on the ability to cast the value 0 as a datetime = 01/01/1900, and -1 as 12/31/1899. Is this...
--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)

September 4, 2009 at 10:16 pm

#1049666
RE: Last Day of any Month

sreid08 (9/4/2009)
I have this page bookmarked because I can never remember how to get the last day of the month -- or some other date functions. It is very...
--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)

September 4, 2009 at 10:09 pm

#1049665
RE: Last Day of any Month

lefrancisco1 (8/26/2009)
Hi Folks,
How to get the Last Day of any month, .bUT FOR EVERY MONTH I SHOULD GETLast DAY
EXAMPLE; LastDay of the month August is 31 with their datename(week...
--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)

September 4, 2009 at 10:07 pm

#1049664
RE: Last Day of any Month

ps (8/26/2009)
SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0)), Case datepart(dw, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+1,0))) When 0 Then 'Sunday' when 1 then 'Monday' When 2 then 'Tuesday' when 3 Then 'Wednesday' When 4 Then 'Friday' When 5 Then 'Saturday' End as Day
Refer - ...
--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)

September 4, 2009 at 10:01 pm

#1049661
RE: Are the posted questions getting worse?

Going way back to the very first post on this thread, the answer is a resounding [font="Arial Black"]YES![/font]
http://www.sqlservercentral.com/Forums/Topic783201-146-1.aspx?
--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)

September 4, 2009 at 9:44 pm

#1049660
RE: how to convert number to minute

I wouldn't use DATEPART to get the time... you'd have to use it more than once depending on what the expected return would be.
Of course, we don't actually know 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)

September 4, 2009 at 9:35 pm

#1049659
RE: An interview with Josef Richberg - The Exceptional DBA of 2009

Conrats indeed. Well done. 🙂
--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)

September 4, 2009 at 7:50 pm

#1049651
RE: IF condition in CURSOR

sudhanva (9/4/2009)
Hey Guys,
Thanks for the huge response and fun here. I didnt expect a 4page posts for this topic 😎
The query which has vendor_id etc was just an example, 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)

September 4, 2009 at 7:33 pm

#1049650
RE: Remove leading zeros and add spaces at the end

chris.fauvel (9/4/2009)
"am I all set?"
yes/no
since there were only 6 skus like that I just updated them, but I would love to have an elegant solution, that is easy.
Thanks
Chris
Like Seth...
--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)

September 4, 2009 at 9:15 am

#1049459
RE: How To Get Table Row Counts Quickly And Painlessly

Good tip... but because it get's it's info from the same place as sp_SpaceUsed, it also has the same problems as sp_SpaceUsed.
--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)

September 4, 2009 at 5:35 am

#1049306
RE: IF condition in CURSOR

David Burrows (9/4/2009)
Jeff Moden (9/3/2009)
.enots ot nrut t'nod I os rorrim a hguorht siht ta gnikool yllautca m'I ...denrawerof neeb d'I 😉
:crazy:
iday eenbay orewarnedfay... imay actuallyay ookinglay atay isthay oughthray...
--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)

September 4, 2009 at 5:28 am

#1049304
RE: Problems to transcript a Oracle SQL Script

franz.ladda (9/3/2009)
Hello together, i have problems to build a T-SQL script for MS SQL 2005, which should do the same like the following Oracle script:
MERGE INTO unknown_ip ip1
USING (SELECT...
--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)

September 3, 2009 at 10:59 pm

#1049214
RE: How to create this kind of Trigger?

Damien (9/3/2009)
THANK YOU VERY MUCH TO YOU ALL!!
Im sorry I did not understand the first one that was suggested to me. I'm starting to read online books regarding trigger....
--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)

September 3, 2009 at 10:21 pm

#1049207

Viewing 15 posts - 42,091 through 42,105 (of 59,102 total)