Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,146 through 35,160 (of 59,102 total)

RE: Calculating Total number of visits

It's ok... you're new. That's why I pointed it out. Thanks for the feedback.
--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)

February 7, 2011 at 9:30 am

#1283231
RE: SQL to split a non delimited string into delimited string

Wolfmeister (2/7/2011)
If my understanding is correct then this method uses a tally table in conjunction with the SUBSTRING function to get the starting positions of each character in @string, 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)

February 7, 2011 at 9:24 am

#1283219
RE: Call for speakers

I'm good with doing virtual presentations. I'll try to put a list of stuff together that I can speak on or would like to speak on.
--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)

February 7, 2011 at 9:20 am

#1283209
RE: I lied, now what?

Everyone holds the person who lied responsible and I do, too. But that doesn't go far enough. I also hold the folks that hired the liar responsible.
--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)

February 7, 2011 at 6:54 am

#1283085
RE: SQL to split a non delimited string into delimited string

ColdCoffee (2/7/2011)
You're welcome,Mr.Wolf 😉
Nicely done, CC.
--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)

February 7, 2011 at 6:33 am

#1283069
RE: SQL to split a non delimited string into delimited string

Wolfmeister (2/7/2011)
That's pretty slick! Thanks guys.
Just making sure... do you understand how ColdCoffee's method works?
--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)

February 7, 2011 at 6:32 am

#1283064
RE: Help with a query

So post your other code so we can see how the two should be "combined".
--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)

February 6, 2011 at 11:03 pm

#1282935
RE: Faster way of cleaning up a table.

I'd probably try to delete fewer rows in every bite but that's basically it. If you have indexed views, they'll be a part of the reason why it goes...
--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)

February 6, 2011 at 11:02 pm

#1282933
RE: Avoid a record that has first character as number in a column

srikant maurya (2/6/2011)
this may help if you Ignore only first number char from Str
select * from Table where isnumeric(left(column_name,1))=0
Oh, be careful now. IsNumeric shouldn't be used as a digit...
--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)

February 6, 2011 at 10:58 pm

#1282931
RE: Calculating Total number of visits

DeJesus (2/6/2011)
Thank you for the quick response but I don't know how using the SUM can return the result expected, it is clear I am missing something.
If you check row...
--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)

February 6, 2011 at 10:33 pm

#1282925
RE: Calculating Total number of visits

{edit} Sorry. Post didn't format properly. See below for replacement.
--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)

February 6, 2011 at 10:29 pm

#1282924
RE: Are the posted questions getting worse?

bitbucket-25253 (2/6/2011)
Jeff Moden (2/5/2011)
Steve Jones - SSC Editor (2/4/2011)
I had the pleasure of Mr. Moden's company at dinner for a couple hours tonight at SQL Saturday #60. If any 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)

February 6, 2011 at 9:18 pm

#1282921
RE: Are the posted questions getting worse?

Grant Fritchey (2/6/2011)
I'm sorry I missed Friday night. I would have loved to have hung out with you guys. Jeff's fun when you get him going. SQL Saturday in Cleveland...
--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)

February 6, 2011 at 9:16 pm

#1282920
RE: Calculating Total number of visits

DeJesus (2/5/2011)
Hi All,
I need help calculating the number of visits in the last 12 months, example data:
CustomerID MonthID MonthDate NumOfVisits
001 ...
--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)

February 5, 2011 at 10:38 pm

#1282839
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (2/4/2011)
I had the pleasure of Mr. Moden's company at dinner for a couple hours tonight at SQL Saturday #60. If any of you find yourself...
--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)

February 5, 2011 at 9:54 pm

#1282838

Viewing 15 posts - 35,146 through 35,160 (of 59,102 total)