Jeff Moden

Forum Replies Created

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

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
RE: Killed a SPID; Not Completing...

dajonx (2/1/2011)
I have attached the results from sp_who2. The stuck SPID is 99. As you can see, the SPID is being blocked by itself. If there 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)

February 4, 2011 at 3:53 pm

#1282746
RE: Table variable as Output Parameter

Oddly enough, I haven't used MERGE in 2k8, yet. But, I believe you'll still need to make that query dynamic SQL using a variable for the USING table name.
--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 4, 2011 at 7:05 am

#1282435
RE: ssis and ssrs interview questions

parmar.randheer11 (2/3/2011)
Hey,
I don’t want to take others opportunity 🙂 I am not job less :-). I know some answers are not up to marks I am correcting those and definitely...
--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 4, 2011 at 6:58 am

#1282430

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