Viewing 15 posts - 4,981 through 4,995 (of 5,678 total)
Subqueries, CTEs, or inline TVFs. Views need to be a single statement. Also remember views aren't encapsulated result sets unless you turn them into indexed views. Any...
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
November 11, 2010 at 9:47 am
Dehqon D. (11/11/2010)
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
November 11, 2010 at 1:06 am
The reason is there is no rownumber as oracle would describe it, and even using a standard identity column wouldn't help in the case of multiple doclinks.
This is what 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
November 11, 2010 at 12:31 am
Digs (11/10/2010)
Thanks..:-) 🙂 🙂I need to run this over about 20,000 records once per day.
I assume this wont blow up. 😉
Nice stuff...
It'll probably blow up, depending on your machine. ...
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
November 10, 2010 at 9:58 pm
Not the cleanest in optimization because of the multiple correlated subqueries, but this will get you on your way I believe. I used a second cte to trim down...
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
November 10, 2010 at 9:52 pm
Digs (11/10/2010)
This is more that a running total, its an index calculation, and I have no idea what all article means..
Unfortunately Digs, the running totals bit is not a simple...
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
November 10, 2010 at 9:41 pm
New post in case of a cross post.
To answer your question more specifically as to what happened with the 6 rows, is this:
select FamilyName, ChildName, CarName
from @FamilyMember f
join @Kids k...
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
November 10, 2010 at 9:28 pm
Ed Srdoc (11/10/2010)
I may have been put off by your initial response that ended in, 'We're not here to do your homework'. Maybe that wasn't directed at me....
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
November 10, 2010 at 9:22 pm
WayneS (11/10/2010)
Craig Farrell (11/10/2010)
Must be the week...http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
Actually, once the OP explained him/her self, I can see where they copped that attitude - the "We're not here to do your homework"...
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
November 10, 2010 at 9:11 pm
Must be the week...
http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
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
November 10, 2010 at 6:32 pm
kiranjanjanam (11/10/2010)
After seeing the posts, I think its the log backups taken out of log shipping that is breaking the log shipping.
i will communicate with the...
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
November 10, 2010 at 6:30 pm
Ed Srdoc (11/10/2010)
Thanks for your reply Craig, but your code doesn't even compile.Maybe I could get somebody that's not such a dick to answer my question!
A) Code compiled just fine...
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
November 10, 2010 at 5:13 pm
Modified slightly because I avoid restricted names like the plague, and you left an extra UNION ALL in there. 🙂
Mind you, you're going to probably have to extrapolate from this...
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
November 10, 2010 at 4:55 pm
The short version is you've got your relationships all twisted up. You're not chaining ChildID into the cars table, you're chaining familyID, which is causing you to link 2*3...
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
November 10, 2010 at 4:45 pm
Sorry, doublepost.
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
November 10, 2010 at 4:45 pm
Viewing 15 posts - 4,981 through 4,995 (of 5,678 total)