Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,416 through 44,430 (of 59,101 total)

RE: function to identify the special characters in a table

SinghS (3/27/2009)
I am struggling with same issue. I want to identify special characters at varchar column so that I can replace it with some other character.
Example: “Hello World”
Space between “Hello”...
--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 28, 2009 at 6:17 pm

#967971
RE: Need help with query

David (3/28/2009)
yes
Heh... bad day, David?
--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 28, 2009 at 6:12 pm

#967970
RE: Comma Separated Values

Koneru Murli Krishna (1/22/2007)
I need deptno and against/beside it comma separated ename's for join dept.deptno=emp.deptno in a single query. Thanks in advance.
Please see the link in my signature below... we...
--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 28, 2009 at 6:10 pm

#967969
RE: Trigger question

Ummmm.... the only way a DELETE trigger that updates the table will cause other triggers to fire is if Cascade Triggers is turned on. It's not normally a good...
--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 28, 2009 at 6:06 pm

#967968
RE: Crosstab type report -- Horizontal Summray

Sorry... almost forgot... spreadsheets and plain text are a bit of a chore because most folks on this forum like to test their code against your good data before posting...
--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 28, 2009 at 6:01 pm

#967967
RE: Crosstab type report -- Horizontal Summray

Joseph Henry (3/28/2009)
Thanks for all of the advice. I'm wondering though.. Can I use Pivot without having aggregate functions? I started to work on a select statement, 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 28, 2009 at 5:57 pm

#967964
RE: String Manipulation

... and here's the code, all cleaned up so it can actually be copied correctly instead of the mess the code window made. Barry, if you test compare against...
--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 28, 2009 at 5:39 pm

#967961
RE: String Manipulation

Man... I just went back and looked at the code I posted... these bloody new code windows added an extra charindex, changed double spaces to single spaces, and did 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 28, 2009 at 4:38 pm

#967956
RE: Just testing the new code window... please disregard

Heh... the outcome of the tests say... nothing's been done so far. BWAA-HAAA!!!! Perhaps this would be a good place to introduce folks to "agile" programming methods 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)

March 28, 2009 at 3:27 pm

#967943
RE: Just testing the new code window... please disregard

Pasted from the code window above minus the double add...
drop table tally
---===== Create and populate the Tally table on the fly
SELECT TOP 11000 ---equates to more than 30 years...
--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 28, 2009 at 3:25 pm

#967942
RE: Just testing the new code window... please disregard

Just a couple of tests to see if they actually did anything for some of the fixes...
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all user...
--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 28, 2009 at 3:23 pm

#967941
RE: Do DBAs Still Read Techincal Books?

sqlblue (3/28/2009)
Jeff, you probably don't remember, but you helped me once...
Anytime someone gives me such an awesome compliment, I'm compelled to go find out what I did right and 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)

March 28, 2009 at 11:45 am

#967910
RE: Do DBAs Still Read Techincal Books?

Steve Jones - Editor (3/28/2009)
Jeff,
I think there's a good call for a T-SQL book from you 🙂
The other thing is that most authors aren't thinking performance when they write. They...
--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 28, 2009 at 11:23 am

#967903
RE: Do DBAs Still Read Techincal Books?

sqlblue (3/28/2009)
Jeff, you probably don't remember, but you helped me once, and I have a tremendous
respect for your technique, knowledge, and for helping me.
I really think you should 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)

March 28, 2009 at 11:04 am

#967900
RE: Do DBAs Still Read Techincal Books?

Heh... all of these conversations have made me revisit some of the books I did buy including some of the ones being talked about. And THAT made me realize...
--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 28, 2009 at 8:18 am

#967878

Viewing 15 posts - 44,416 through 44,430 (of 59,101 total)