Jeff Moden

Forum Replies Created

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

RE: Finding hierarchy errors

Once you have all of the problems resolved with the "non-existing parent" problem, you should add a self-referencing FK that contrains the values of parentIDs to only those values available...
--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 8:12 am

#1689928
RE: Help with Query Output

kalikoi (2/18/2014)
I have three tables as follows
TableA
------
Col1 col2 col3
1 C01 1
2 C02 2
3 C03 1
4...
--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 6:52 am

#1689882
RE: Idera SQL Safe tool help - how to remove records from the repository or from alerts

My recommendation would be to see if the built in "Help" for Idera might save you some time. It's most likely that pressing the {f1} key while the tool...
--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 6:49 am

#1689880
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

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