Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,366 through 31,380 (of 59,101 total)

RE: Jiggly Code

I think the problem isn't so much the direct fault of the people doing the work. I think it's the culture that has been developed over the years 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)

January 23, 2012 at 6:39 am

#1437053
RE: Jiggly Code

GSquared (1/23/2012)
I have to admit, I'm sometimes guilty of "jiggling the code till it unbreaks".
I've had to do that in order to teach myself what little I know of XQuery...
--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)

January 23, 2012 at 6:33 am

#1437049
RE: storing CSV in a column vs. table with records

Yet, ironically, people let other people store XML in their database. Go figure. 😉
If you change the structure of the table now, be advised that you'll also have 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)

January 23, 2012 at 6:27 am

#1437044
RE: The new Analytic functions in SQL Server 2012

Wonderful article, Wayne. The charts summarize a nicely laid out and well written article and make it real easy to get extra information. Thanks for taking the time...
--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)

January 20, 2012 at 9:56 am

#1436617
RE: Cannot remove blank espace

luissantos (1/20/2012)
Hello
Your TSQL return error RIGHT, i run like this
SELECT ASCII(RIGHT(CCT,20))
from cu
WHERE cct like '72.1.107%'
QA return : 55
I solve my problem using this UPDATE:
update cu
set cct = substring(cct,1,8)
from cu...
--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)

January 20, 2012 at 9:40 am

#1436610
RE: STR function

Chiming in...
http://www.sqlservercentral.com/articles/T-SQL/71565/
--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)

January 20, 2012 at 6:28 am

#1436435
RE: Convert Column value to Row

See the following article for how to easily do Crosstabs and Pivots:
http://www.sqlservercentral.com/articles/T-SQL/63681/
See the first link in my signature below if you'd like a coded answer.
--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)

January 20, 2012 at 6:25 am

#1436434
RE: Cannot remove blank espace

What does the following return?
SELECT ASCII(RIGHT(cct ))
FROM cu
WHERE cct LIKE '72.1.107%'
--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)

January 20, 2012 at 6:16 am

#1436425
RE: How to extract part of URL from varchar column?

tetroxide (1/19/2012)
you could probably write something like a split function to grab out the individual pieces using a loop.
As a sidebar... loops are not required for such a thing....
--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)

January 19, 2012 at 7:09 pm

#1436264
RE: Is there an accurate script for datediff format in years:months:days?

That's why I asked the question about how long a month was. It won't necessarily be accurate for 90 days with different start dates. Even 30 days is...
--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)

January 19, 2012 at 6:51 pm

#1436262
RE: Are the posted questions getting worse?

Brandie Tarvin (1/19/2012)
If I've already announced this here, I apologize for the repost. I'm just so excited I can't remember where all I've shared the news already.
I am beyond thrilled...
--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)

January 19, 2012 at 6:01 pm

#1436256
RE: Is there an accurate script for datediff format in years:months:days?

Ummm.... how long is a month for this particular problem?
--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)

January 19, 2012 at 6:15 am

#1435769
RE: Parse data

oradbguru (1/18/2012)
Hello, I am trying to parse data and put in seperate columns if possible. For example:
332|347
348|332|342|343
I want to have:
col1 col2 col3 ...
--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)

January 19, 2012 at 6:13 am

#1435766
RE: Wrapper to run stored procedure many times

Cadavre (1/18/2012)
GSquared (1/18/2012)
Cadavre (1/18/2012)
adrian.facio (1/18/2012)
Did you tried it before your change??
Admittedly, the answer to that is "no".
However IMO, to avoid ambiguity, whether or not your method works is...
--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)

January 18, 2012 at 1:53 pm

#1435495
RE: Creating a round robin table with SQL & VB

Dang it! I'm sorry. I lost track of this thread. :blush:
I said I had worked out the math for a Round Robin schedule but not the "Field 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)

January 17, 2012 at 9:14 pm

#1434970

Viewing 15 posts - 31,366 through 31,380 (of 59,101 total)