Viewing 15 posts - 1,846 through 1,860 (of 5,678 total)
jamie_collins (1/31/2012)
I am going to play around with it... I may need to add the AUDITDATETIME field in at some point and then reverse the query so I can...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 1, 2012 at 1:03 am
sartis (1/31/2012)
I apologize I...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 1, 2012 at 12:59 am
If you take a look at the first link in my signature, it'll show you how we prefer your sample stuff to be setup so we can use it instead...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 1, 2012 at 12:54 am
There isn't an alternate. Because dependency association is less than perfect, sp_refreshview is the only way to change the metadata if the underlying schema changes. You could just...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 1, 2012 at 12:52 am
steve 22165 (1/31/2012)
In the where clause the 5142 is an id of the person.....so that is why...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 5:08 pm
Jeff Moden (1/31/2012)
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
It's a...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 4:41 pm
steve 22165 (1/31/2012)
Projects table has these columns and there is example data below
---------------------------------------------------------------------------
Project_name_id Project name
1...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 4:37 pm
DavidL (1/31/2012)
Here is the stored procedure text. It is very slightly different what I first posted, but not in essence. There are no SET... statements...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 4:31 pm
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
It's only paranoia if...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 3:52 pm
Jack Corbett (1/31/2012)
I'll have to play around a bit with the sample...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 3:48 pm
zwheeler (1/31/2012)
Question:
FETCH NEXT FROM Cur1 INTO @pid_A, @date_start_A, @date_end_A
FETCH NEXT FROM Cur1 INTO @pid_B, @date_start_B, @date_end_B
When the sql is executed for Cur1
does this contain the same rows or does...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 3:45 pm
Thanks for the additional information above David. So, some clarifications if you'll be so kind, and hopefully some ideas on what we can look for in regards to troubleshooting.
DavidL...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 3:40 pm
Personally I usually end up having to write up trees, or get a little zany with bullets, or sketch a quick mental diagram, or...
... I get tired trying to pull...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 3:28 pm
Dbloc (1/31/2012)
So...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 1:09 pm
Without schema, I can't hand you actual code, but what's the concern doing something like the following:
SELECT
BldgID,
UserID,
Max(SomeDate) AS MaxDate,
Min(SomeDAte) AS MinDate
FROM
-- Joins go here
GROUP BY
BldgID,
UserID
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2012 at 12:13 pm
Viewing 15 posts - 1,846 through 1,860 (of 5,678 total)