Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,921 through 25,935 (of 59,099 total)

RE: Need help in building a SQL query?

Alan.B (9/17/2013)
Well done Magoo; I knew there was a much better way but drew a blank.
Jeff Moden (9/16/2013)
Just to backup Maggo's solution... the method he used is called 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)

September 17, 2013 at 4:30 pm

#1650971
RE: Command to execute Copy,Delete etc instead of XP_cmdShell

srajinigandh (9/17/2013)
...company standards now does not permit usage of XP_cmdshell as it has security flaws, ...
Sigh....
That's like saying that DELETE has a flaw in it because it will delete...
--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)

September 17, 2013 at 4:25 pm

#1650970
RE: Setting Different Colors for Connections in SSMS

Peter Schott (9/17/2013)
Jeff Moden (9/17/2013)
Peter Schott (9/17/2013)
Jeff Moden (9/17/2013)
I'm not sure what's going on but I'm using SQL Server 2005 Developer's Edition (SP3) and the "Use Custom Color" checkbox 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)

September 17, 2013 at 3:58 pm

#1650962
RE: Intelligently Flatten Ragged Hierachy to Fixed Levels for SSAS

busraker (9/17/2013)
Jeff Moden (9/17/2013)[/b
Heh... you need to ignore those "multiple sources" because they're condeming one of the easier methods to maintain hierarchical data there is.
Well, one of those sources (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)

September 17, 2013 at 3:55 pm

#1650961
RE: Intelligently Flatten Ragged Hierachy to Fixed Levels for SSAS

busraker (9/17/2013)
...but of course according to multiple sources I should not use parent/child hierarchies,...
Heh... you need to ignore those "multiple sources" because they're condeming one of the easier methods 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)

September 17, 2013 at 1:25 pm

#1650906
RE: Best Practices Article or Video

To add to that, be very aware that what some folks call "Best Practices" are nothing more than wanton personal opinion or sometimes based on "standards" that are impossible 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)

September 17, 2013 at 1:21 pm

#1650905
RE: Setting Different Colors for Connections in SSMS

Peter Schott (9/17/2013)
Jeff Moden (9/17/2013)
I'm not sure what's going on but I'm using SQL Server 2005 Developer's Edition (SP3) and the "Use Custom Color" checkbox is not present. 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)

September 17, 2013 at 12:21 pm

#1650889
RE: Systems Engineer - is it a good career goal for DBA?

o103452 (9/17/2013)
I wonder what to do next: keep learning SQL Server, or exand my knowledge to Windows.
I would say, why not do both
The real question is -- is there 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)

September 17, 2013 at 12:18 pm

#1650888
RE: Setting Different Colors for Connections in SSMS

I'm not sure what's going on but I'm using SQL Server 2005 Developer's Edition (SP3) and the "Use Custom Color" checkbox is not present. Are you sure that this...
--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)

September 17, 2013 at 8:48 am

#1650821
RE: Systems Engineer - is it a good career goal for DBA?

o103452 (9/16/2013)
I'm a SQL Server DBA with 6 years experience.
My job is entirely focused on SQL Server and I don't even have to touch other platforms or software.
Learning Windows Admin...
--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)

September 16, 2013 at 7:25 pm

#1650668
RE: Query with One Column Changing by Month

jkalmar 43328 (9/16/2013)
Thanks Bob. Maybe "efficient" is the wrong word - it just kills me to see that block of code repeated twelve times.
Me too.:-)
First, I would be remiss in...
--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)

September 16, 2013 at 7:16 pm

#1650667
RE: Advice on complex logic with embedded functions.

This doesn't seem that complex but I can't know for sure because I know nothing of your tables and nothing of the data. As it is, my recommedation would...
--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)

September 16, 2013 at 7:03 pm

#1650665
RE: Need help in building a SQL query?

Just to backup Maggo's solution... the method he used is called a "CROSSTAB". You could also use a PIVOT although the CROSSTAB solution is usually a touch faster. ...
--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)

September 16, 2013 at 6:52 pm

#1650662
RE: Extract string between to characters

Trestire (9/13/2013)
First of all thanks for your time.
I'll paraphrase my post:
I've a string in following format. I've this string in my a table column:
<1|458|test|q><2|789|test2|s><5|567|test3|p>
First I've to extract the strings between...
--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)

September 16, 2013 at 6:37 pm

#1650660
RE: Rounding a number up to the nearest 5

smrobin (9/16/2013)
Thanks for the replies guy! I used your combined logic and got it to work! Thanks again - love this site!
Two way street here, my friend. ...
--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)

September 16, 2013 at 6:06 pm

#1650651

Viewing 15 posts - 25,921 through 25,935 (of 59,099 total)