Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,171 through 22,185 (of 59,072 total)

RE: Are the posted questions getting worse?

GilaMonster (12/22/2014)
Someone, please, help! http://www.sqlservercentral.com/Forums/Topic1645843-1549-1.aspx
Heh... WHAT? Nah... he doesn't need any help. He only lost 1 day of business. :-):-D:-P
--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)

December 22, 2014 at 2:13 pm

#1766072
RE: Are the posted questions getting worse?

... OR... you just fix the crap code you found and celebrate with a beer and a chew. 😀
--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)

December 22, 2014 at 2:08 pm

#1766071
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/22/2014)
jasona.work (12/22/2014)
Stefan Krzywicki (12/22/2014)
Steve Thompson-454462 (12/22/2014)
Stefan Krzywicki (12/22/2014)
Steve Thompson-454462 (12/22/2014)
Brandie Tarvin (12/16/2014)
But still... To my mind, since I'm already fixing one part of the package, why shouldn't 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)

December 22, 2014 at 2:06 pm

#1766070
RE: How to format unformated phone numbers Please...,

CELKO (12/22/2014)
Pull all the punctuation out and pad with digits as needed until you get the Standard International phone number. Let the presentation layers handle presentations.
http://en.wikipedia.org/wiki/E.123
You also might want...
--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)

December 22, 2014 at 2:03 pm

#1766069
RE: How to format unformated phone numbers Please...,

Oh, I definitely agree, Kevin. Sometimes you do have to play with the cards you're dealt. I do try to get the dealer to deal better cards, though.
So,...
--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)

December 21, 2014 at 2:15 pm

#1765893
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

Thanks, Gabe. 🙂
--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)

December 21, 2014 at 2:11 pm

#1765892
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (12/19/2014)
SQLRNNR (12/19/2014)
Steve Jones - SSC Editor (12/19/2014)
Merry Christmas and Happy Holidays, everyone.
I'll be gone after tomorrow, heading away for a week. Everyone behave.
Yay -...
--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)

December 21, 2014 at 1:21 pm

#1765891
RE: What To Do When the Import and Export Wizard Fails - Part II Exports

Divine Flame (12/18/2014)
Yakov Shlafman (12/18/2014)
Thanks for your input. What do you mean by saying Actual Information was lost? How do you like this saying: Make everything as simple as possible,...
--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)

December 18, 2014 at 8:32 am

#1765489
RE: Need Help Writing a SQL Query that can provide a 6 Month Forecast

Lee Polikoff (12/17/2014)
Background is that I am recreating charts in SSRS that were being created in Excel. The source data is residing in a SQL Server database. I'm having 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)

December 17, 2014 at 1:55 pm

#1765283
RE: Calculating Last 5 Business Days and Next 5Days

jshuter (12/17/2014)
I understand the need to use SQL when doing SQL but a little looping wont kill ya 🙂
I know thousands of people that agree with you... they've all...
--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)

December 17, 2014 at 1:23 pm

#1765274
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

Phil Parkin (12/17/2014)
... though I would not categorise a CROSS JOIN as advanced.
Heh... you're also not a neophyte, Phil. All the "heavy hitters" take it for granted. ...
--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)

December 17, 2014 at 7:08 am

#1765168
RE: Designing a "Web" dashboard to monitor SQL Server Jobs

Brandie Tarvin (12/17/2014)
So I have it in my head to design a webpage that my team can pull up at month end and, at a glance, tell what jobs 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)

December 17, 2014 at 6:59 am

#1765164
RE: Are the posted questions getting worse?

Koen Verbeeck (12/17/2014)
Brandie Tarvin (12/17/2014)
Brandie Tarvin (12/16/2014)
WHOO! #HappySnoopyDance
I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8...
--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)

December 17, 2014 at 6:50 am

#1765162
RE: Stairway to Advanced T-SQL Level 1: Introduction to Advanced Transact SQL Stairway and Using the CROSS JOIN Operator

From the Article:
CREATE TABLE Cust (Id int, CustName varchar(20));
CREATE TABLE Sales (Id int identity
...
--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)

December 17, 2014 at 1:56 am

#1765094
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/16/2014)
Jack Corbett (12/16/2014)
Stefan Krzywicki (12/16/2014)
Eirikur Eiriksson (12/16/2014)
Stefan Krzywicki (12/16/2014)
Eirikur Eiriksson (12/16/2014)
Jeff Moden (12/16/2014)
Steve Jones - SSC Editor (12/15/2014)
Jeff Moden (12/14/2014)
In the category of learning something new,...
--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)

December 16, 2014 at 5:38 pm

#1765063

Viewing 15 posts - 22,171 through 22,185 (of 59,072 total)