Viewing 15 posts - 631 through 645 (of 5,678 total)
RexHelios (5/29/2013)
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
May 29, 2013 at 6:20 pm
For your dataset query, are you using a text command type or stored procedure?
EDIT: I should have been more clear. You can set the parameter in the node to...
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
May 29, 2013 at 5:53 pm
I'm... confused I think.
Can you list out your schema and some sample data in a consumable format, along with the triggers you've built so far? It would be far...
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
May 29, 2013 at 5:43 pm
Not directly, at least not with SSRS. You'd need more of an interface to pass down parameters for rowcounts and starting rows to a proc which would restrict 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
May 29, 2013 at 5:41 pm
The Dixie Flatline (5/29/2013)
If 42 is the answer (to life, the universe, and everything), what is the question?
How many mice did the cats eat before the mice stopped being sentient?
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
May 29, 2013 at 4:46 pm
I believe the order of operations is what's confusing you, along with a secondary syntax for IF.
There are two ways to write an IF:
IF 1=1
PRINT 'One Command Only Active'
BEGIN
PRINT...
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
May 29, 2013 at 4:05 pm
I was about to suggest that then realized you'd found your answer as I read down.
There are two things you always do for any stored procedure that's more complex than...
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
May 29, 2013 at 4:01 pm
There is no countdown, there is only Zuul...
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
May 29, 2013 at 3:55 pm
Michael Valentine Jones (5/29/2013)
Are there Non-Functional DBAs?
Yes, but the one I have in mind hasn't posted here in a while and I'm afraid to invoke his name.
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
May 29, 2013 at 1:07 pm
Out of curiosity, can you move category_id up to #rateheader? That seems like the most logical place for it long-term, and means you won't end up with one...
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
May 24, 2013 at 6:32 pm
brickpack (5/24/2013)
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
May 24, 2013 at 6:28 pm
Well, I think this gets you where you need to be:
SELECT
c.Category_Name,
COUNT(*) AS Total
FROM
(SELECT DISTINCT
category_id,
rg_id
FROM
#rate
) AS drv
JOIN
#product_category AS c
ONdrv.Category_id = c.Category_id
GROUP BY
c.Category_Name
I converted things to #tables so if you need those:
CREATE...
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
May 24, 2013 at 6:04 pm
Without sample schema and data we're trying to offer you ideas, not perfect error free code.
If you would like us to be able to provide solutions that are (nearly) guaranteed...
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
May 24, 2013 at 5:35 pm
*scratches head*
Okay, you've officially confused me... and I thought I understood it, so bear with me. Is my assumption correct that the rate table has a 'minimum bought' column...
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
May 24, 2013 at 5:31 pm
For the love of gods...
THANK YOU. 😀
I owe you a beer. Or ten.
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
May 24, 2013 at 4:56 pm
Viewing 15 posts - 631 through 645 (of 5,678 total)