Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,666 through 31,680 (of 59,099 total)

RE: First letter upper case for each word in sql server.

@Lowell,
Just to prevent accidental use of the bad copy of the code, would you mind editing your post to remove the code? Thanks my friend.
And, to be sure, 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)

December 15, 2011 at 6:13 am

#1421869
RE: First letter upper case for each word in sql server.

I'm not sure how the code Lowell posted got messed up (forum software will sometimes do that to special characters) but that code is missing all of the "^" characters...
--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 15, 2011 at 6:05 am

#1421864
RE: First letter upper case for each word in sql server.

bhaveshp.dba (12/9/2011)
The function is nor returning right result set.
SELECT Common.InitialCap ('ABINGTON HEALTH LANSDALE HOSP')
ouput
ABINGTON HEALTH LANSDALE HOSP.
Please let me know if any change.
Thanks
Bhavesh
Damn. You're right. I'll 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)

December 15, 2011 at 5:51 am

#1421861
RE: Please answer to these questions

sqldba2k8 (12/15/2011)
I am working in developement platform.now i want to move admin side.thats why i attending interviews.
Congrats on the good intentions but I believe you've put the cart before 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)

December 15, 2011 at 5:45 am

#1421860
RE: Create parameter from getdate() to extract all previous years

pwalter83 (12/15/2011)
Thanks a lot Jeff, that's really helpful !!! I am thinking of replacing my code with your one...:-)
You bet and thank you for the feedback. Shifting gears, please...
--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 15, 2011 at 5:17 am

#1421850
RE: Using SP_

Revenant (12/14/2011)
bitbucket-25253 (12/14/2011)
Jeff Moden (12/14/2011)
BWAA-HAAA!!! Judging by the fact that more people got the wrong answer than the correct one, I'd say you just taught a whole bunch 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 15, 2011 at 4:57 am

#1421846
RE: Are the posted questions getting worse?

Evil Kraig F (12/14/2011)
Hey Jeff, I got the ultimate compliment earlier. Someone who didn't read my name on my post mistook me for you after point them in 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)

December 15, 2011 at 4:42 am

#1421838
RE: 8hr hour query ?!?!?!?!?!?!?!

GilaMonster (12/15/2011)
Jeff Moden (12/14/2011)
with a touch of the "Halloween Effect" (essentially, a cursor within a cursor behind the scenes).
????
Something you've named 'halloween effect'? Because what's normally referred 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)

December 15, 2011 at 4:34 am

#1421833
RE: Create parameter from getdate() to extract all previous years

raultr (12/14/2011)
whitout table, you can use
DECLARE @FEC_INI DATETIME, @FEC_FIN DATETIME
SELECT @FEC_INI = '01/01/1900', @FEC_FIN = '31/12/2010';
WITH DIAS AS
(
SELECT @FEC_INI AS FEC
UNION ALL
...
--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 14, 2011 at 9:15 pm

#1421718
RE: Create parameter from getdate() to extract all previous years

pwalter83 (12/14/2011)
Hi,
I have a requirement to display all previous years starting from 2010 and above as parameters. The only way I can think of doing it currently is through 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)

December 14, 2011 at 9:13 pm

#1421717
RE: Convert DATE to Integer8 (64 Bit)

nfs_john (12/13/2011)
So is there a function to convert a date time to and integer given an epoch date or do I need to write that as well?
Which epoch date 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)

December 14, 2011 at 7:53 pm

#1421709
RE: Export to destination file - multiple rows to one

buddy_bell (12/14/2011)
My issue is if there 2 rows (questions and answers) for one ID and 3 rows for another ID. I feel I need to somehow loop through and write...
--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 14, 2011 at 7:49 pm

#1421708
RE: how to shrink this DB without suffering downtime?

mrTexasFreedom (12/14/2011)
Thanks for the info. I think this is my last question....
Should I rebuild the indexes after every incremental shrink?
-- mtf
It takes scant seconds to shrink a 50GB logfile during...
--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 14, 2011 at 7:45 pm

#1421707
RE: 8hr hour query ?!?!?!?!?!?!?!

Fraggle-805517 (12/14/2011)
Hey everyone. I am having a rather bad day. Must be blind or something. The following statement is taking roughly 8 hours to run to completion.
DELETE...
--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 14, 2011 at 7:39 pm

#1421705
RE: Pivot Table Headache

bill.sutcliffe (12/14/2011)
My boss forgot to tell me he wants to be able to select a date range for this. Any idea how to do this without knowing how 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)

December 14, 2011 at 7:30 pm

#1421702

Viewing 15 posts - 31,666 through 31,680 (of 59,099 total)