Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,571 through 42,585 (of 59,098 total)

RE: Split a result by commas

purplebirky (8/3/2009)
in this table one column has entrys that look like : res1, res2, res3
well i need to split these out to return each on it's own.
purplebirky,
See the article 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)

August 4, 2009 at 2:18 pm

#1034518
RE: Split a result by commas

AVB (8/4/2009)
Jeff,
Good article. I'll have to try that next opportunity I get!
Thanks for the feedback, AVB.
--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)

August 4, 2009 at 2:17 pm

#1034517
RE: how to write a function that executes Sub- Store procedure

I'm pretty sure I can't actually help on this because I don't know well enough what the two procs do, but this is all RBAR... is there no way 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)

August 4, 2009 at 10:50 am

#1034414
RE: Split a result by commas

AVB (8/4/2009)
If the data is going to be different lengths then the code I provided would not work although it can be modified to do so.
As far as the function...
--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)

August 4, 2009 at 10:37 am

#1034406
RE: Creating View without duplicates, hope this not a dumb question lol

For more information on how the method Lynn used actually works, please see the following article...
http://www.sqlservercentral.com/articles/T-SQL/62867/
In the code Lynn posted, he used a really cool CTE similar to what Itzek...
--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)

August 4, 2009 at 10:33 am

#1034404
RE: Date conversion

SQL (8/3/2009)
I agree that formmating in the front end is the way to go if possible as far as the question is concerned.
On a more general note, however, there are...
--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)

August 4, 2009 at 10:23 am

#1034396
RE: Date conversion

nigel (8/3/2009)
Jeff Moden (8/2/2009)
Does SSRS have something in it to take an SQL DateTime and format it for display without disturbing the sortability of the underlying SQL DateTime?
Yes, 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)

August 4, 2009 at 9:45 am

#1034360
RE: Date conversion

john.arnott (8/3/2009)
Mike,
Welcome to SSC and thank you for sharing that function.
You should consider your head safe..... Your post made it clear that defining a function to do...
--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)

August 4, 2009 at 9:41 am

#1034359
RE: Curly question I can't work out without cursors!

ta.bu.shi.da.yu (8/3/2009)
I'm hoping Jeff Modem can help me on this one 🙂
Heh... thank you for the compliment but, as you can see, I'm not the only show in town. ...
--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)

August 4, 2009 at 9:29 am

#1034346
RE: Curly question I can't work out without cursors!

Nah... I didn't miss anything... Andrew not only did it the way I would have, he even cited the same URL I was going to cite where I first saw...
--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)

August 4, 2009 at 9:25 am

#1034342
RE: Curly question I can't work out without cursors!

And this was an accidental double post from above.
--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)

August 4, 2009 at 8:27 am

#1034282
RE: Curly question I can't work out without cursors!

Sorry... I missed something... had to take the code down from this post... I'll be back.
--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)

August 4, 2009 at 8:24 am

#1034278
RE: Is it normal that varchar variable is automatically trimmed in t-sql ?

I'll also add that you should propably get used to this because SET ANSI_PADDING OFF has been deprecated as have the "off" conditions for many ANSI settings 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)

August 3, 2009 at 8:46 pm

#1034048
RE: treatment of white space in string operations

I guess I don't understand... textual datatypes are naturally "left justified" and there is no need to RPAD.
--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)

August 3, 2009 at 8:44 pm

#1034046
RE: How to join Candidate and Qualification tables

Chandu (8/3/2009)
Hi Jeff, I think pande wants the output in the following way
Thanks, Chandu... but, why can't OPs like this get the hint? We had a very simple request......
--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)

August 3, 2009 at 8:25 pm

#1034041

Viewing 15 posts - 42,571 through 42,585 (of 59,098 total)