Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,346 through 24,360 (of 59,099 total)

RE: trying to add third grouping set to return average aggregate

The real problem is the GROUPING SETS. The averages are computed based on the grouping. I'll have to think about this some other time. It's 02:10 here...
--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 18, 2014 at 12:11 am

#1689754
RE: Selecting rows in a table.. not so simple!

dwain.c (2/10/2014)
A man of mystery then. Not so easy to climb into your mind as you may think.
Not so mysterious. I gave you a hint. Look at...
--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 18, 2014 at 12:04 am

#1689753
RE: result in text file?

Eugene Elutin (2/11/2014)
Why not just a simple script (in whatever scripting language) which executes proc and outputs into file in a better location.
I know it'll be viewed as a personal...
--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 18, 2014 at 12:01 am

#1689751
RE: Regarding Audits in sql server

Jeff Moden (2/4/2014)
p.avinash689 (2/4/2014)
Hi All,
I'm using Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation...
--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 17, 2014 at 11:56 pm

#1689747
RE: OS Disk Capacity Information

SQLRNNR (2/7/2014)
@jeff and others,
You might be interested in this solution provided here.
http://sqlblog.com/blogs/merrill_aldrich/archive/2011/01/04/posh-y-sql-disk-space-monitoring.aspx
Thanks, Jason. Man! That's a lot of code, though. I thought my stuff was long.
--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 17, 2014 at 11:49 pm

#1689745
RE: Hires by month issue

ps_vbdev (2/6/2014)
"The "5" in both forumlas could be any constant but either 1 or 5 seem to be the easiest to understand"
so the 5 is an arbitrary value that 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 17, 2014 at 11:33 pm

#1689744
RE: Help with date in sQL

dhananjay.nagarkar (2/6/2014)
Dear Jeff,
thanks for helping me with the code.
It worked accurately as per need.
Kind Regards
DJ
You're welcome. I get lucky, sometimes.
--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 17, 2014 at 11:30 pm

#1689743
RE: Complicated query with sample data

stmu009 (1/31/2014)
Definitely better than using cursors.
I lean toward them more than subqueries.
I prefer them over using temp tables in most cases.
I can probably do a quick google search for...
--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 17, 2014 at 11:19 pm

#1689741
RE: Code to list the Week Number of Year

@Clare,
Are you all set one way or the other now?
--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 17, 2014 at 11:12 pm

#1689740
RE: trying to add third grouping set to return average aggregate

Thank you very much for the explanation as to why you needed the data this way. I always wonder about these things.
I believe this may be what you asked...
--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 17, 2014 at 11:06 pm

#1689738
RE: 15 minutes Interval from Hours - Please Help

dwain.c (2/17/2014)
Jeff Moden (2/17/2014)
zulfansari (2/17/2014)
Hi Jeff, Dwain.c and SQLRNNR,
You guys are AWESOME..
I really appreciate your help and learned new tips and tricks from all of you..
God bless you all!
Just an...
--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 17, 2014 at 10:16 pm

#1689727
RE: trying to add third grouping set to return average aggregate

KoldCoffee (2/17/2014)
Do you mind telling me if I could have added something to my existing query to get avg too?
To be honest, I've never had to use GROUPING SETS...
--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 17, 2014 at 9:59 pm

#1689723
RE: LIKE and NULLs

thisisfutile (2/17/2014)
Jeff Moden (2/16/2014)
thisisfutile (2/14/2014)
fsuoj (2/14/2014)
Where is it documented that not using % assumes % at the end?
The Insert "trims" the trailing spaces from the data.
Not quite right. Trailing...
--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 17, 2014 at 9:42 pm

#1689720
RE: LIKE and NULLs

fsuoj (2/17/2014)
I am not trying to be difficult but no one in this thread has answered my question. How does SQL know to look for anything trailing the AAA...
--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 17, 2014 at 9:41 pm

#1689719
RE: To T-SQL or not to T-SQL?

sqldriver (2/17/2014)
I think doing that bit of pre-processing with PS should be fine; it's just one line, even if it is ~75 times.
It would be interesting to see which approach...
--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 17, 2014 at 9:25 pm

#1689717

Viewing 15 posts - 24,346 through 24,360 (of 59,099 total)