Viewing 15 posts - 4,021 through 4,035 (of 5,678 total)
Matt_V (2/14/2011)
Quick question,...
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 14, 2011 at 1:08 pm
Have you looked at the for each object in SSIS? Perform a loop using the file name's pattern to find all the instances, and then do what's necessary 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
February 14, 2011 at 12:24 pm
I could think of a few ways, such as doing an UNPIVOT on the data, assigning row_numbers partitioning on ID and ordering by the value, but they're no less complex...
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 14, 2011 at 12:20 pm
WayneS (2/14/2011)
Craig Farrell (2/14/2011)
Grant Fritchey (2/14/2011)
Roy Ernest (2/14/2011)
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 14, 2011 at 12:18 pm
Grant Fritchey (2/14/2011)
Roy Ernest (2/14/2011)
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 14, 2011 at 12:10 pm
At the time of this posting, 18 ppl got it wrong.
I have to wonder, are they simply people who answer (E) to every question on the SAT, 18 people who...
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 14, 2011 at 12:01 pm
GilaMonster (2/14/2011)
Another promising looking contract cancelled due to lack of @#$$#@$%$ budget!
I'm almost at the point of walking away and going to work in a book store for 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
February 14, 2011 at 11:22 am
Jeff Moden (2/13/2011)
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 14, 2011 at 2:38 am
Jeff Moden (2/13/2011)
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 14, 2011 at 2:35 am
Try this:
SELECT a.DocNum,Convert(varchar(10),a.DocDate,103)'DocDate',a.cardcode,a.cardname, a.Doctotal,
(Select SUM(Doctotal) from ORCT where a.cardcode='C000732' AND a.DocDate>='2010/04/01' AND a.DocDate<='2011/02/14' and DocNum <=a.DocNum ) AS RunningTotal
FROM ORct a where a.cardcode='C000732' AND a.DocDate>='2010/04/01' AND a.DocDate<='2011/02/14'
GROUP BY a.DocNum ,a.DocDate,...
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 13, 2011 at 11:16 pm
What Pankush said above is correct.
However, when you do review table hints, you'll always want to throw in a comment about them being done only as a last resort, and...
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 13, 2011 at 10:50 pm
It's because in this statement:
SELECT a.DocNum,Convert(varchar(10),a.DocDate,103)'DocDate',a.cardcode,a.cardname, a.Doctotal,
(Select SUM(Doctotal) from ORCT where cardcode='C000732'
and DocNum <=a.DocNum ) AS RunningTotal
FROM ORct a where a.cardcode='C000732' AND a.DocDate>='2010/04/01' AND a.DocDate<='2011/02/14
GROUP BY a.DocNum ,a.DocDate, a.Doctotal,a.cardcode,a.cardname
ORDER BY...
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 13, 2011 at 10:44 pm
I'm not sure what I can add to what Grant said about the tools, however, a few additional things to think of.
One of the things that will help to guide...
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 13, 2011 at 10:15 pm
What does this query do?
My first instinct is to tell you to look at the waitstate on the proc while it runs slow during the day. Next thing I'd...
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 13, 2011 at 10:04 pm
Anamika (2/13/2011)
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 13, 2011 at 10:02 pm
Viewing 15 posts - 4,021 through 4,035 (of 5,678 total)