Viewing 15 posts - 1,501 through 1,515 (of 5,678 total)
krypto69 (6/8/2012)
Hi Lynn,Thanks for your reply.
Yep, join sure sounds like what I need.
How would I go about that type of join?
Krypto, that would be difficult for us to answer...
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
June 8, 2012 at 2:09 pm
Lynn Pettis (6/8/2012)
OP: I don't want a union. How do I put these two queries together?
Me: Looks like you need a join.
OP: ...
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
June 8, 2012 at 1:58 pm
azdeji (6/8/2012)
Can you help me with one more question releating to folders and Variables?
Is there any way to retrieve the folder name for...
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
June 8, 2012 at 1:56 pm
Revenant (6/8/2012)
GilaMonster (6/8/2012)
Would probably...
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
June 8, 2012 at 1:23 pm
Greg Edwards-268690 (6/7/2012)
Stefan Krzywicki (6/7/2012)
Revenant (6/7/2012)
For an intermedaite or senior BI developer, I would probably add "understanding of business statistics." By that I mean a good grasp of applicability of...
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
June 8, 2012 at 1:21 pm
What you're looking to do is really return two different recordsets. The first query in a union defines what the field types/names/etc are. This is what we call...
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
June 8, 2012 at 1:10 pm
Stewart's method is about the only way in pure T-SQL to perform that task, using IsDate() and then converting or returning null based on the result of IsDate().
Just make sure...
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
June 5, 2012 at 6:56 pm
ReginaR1975 (6/5/2012)
Thank you for the responses. I'll try not to use views. 🙂
I wouldn't avoid using views, I'd just make sure I understand the limitations of them. The reason...
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
June 5, 2012 at 6:52 pm
GilaMonster (6/5/2012)
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
June 5, 2012 at 5:05 pm
We don't have the UserProductivityMapping INNER JOIN Weeks wk...
Can you copy/paste the result of your print statement? I believe the error's most likely in that, not in your actual...
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
June 5, 2012 at 1:10 am
The method you want is either a Crosstab query or the PIVOT function, but the problem with both of those is you typically want to know how many columns you're...
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
June 5, 2012 at 1:01 am
ScottPletcher (6/4/2012)
@scott: By best practice you never store your unencryption mechanisms and your data in the same place. Admittedly, there are times when you may need to work 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
June 4, 2012 at 5:57 pm
blampe (6/4/2012)
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
June 4, 2012 at 4:48 pm
blampe (6/4/2012)
Disclaimer, I am new to sql and new to these forums so bear with me on this one.
Not a problem, particularly since you're looking to help yourself and not...
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
June 4, 2012 at 3:44 pm
Jeff Moden (6/4/2012)
ScottPletcher (6/4/2012)
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
June 4, 2012 at 3:03 pm
Viewing 15 posts - 1,501 through 1,515 (of 5,678 total)