Viewing 15 posts - 5,656 through 5,670 (of 5,678 total)
You're on the right track in both cases. For non real time/overnight updates, you'd build an SSIS job and then schedule it with SQL Agent.
If you need real-time access,...
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
September 2, 2010 at 3:58 pm
Well, the inner joins are limiting the results. There are custnmbr/docnumber combos existing in RM20101 that aren't in CN20100, and noteindx in RM20101 that don't exist in CN00300.
My first...
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
September 2, 2010 at 3:54 pm
bkmooney (9/2/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
September 2, 2010 at 2:57 pm
SELECT SUBSTRING( @field, CHARINDEX( '~', @field)+1, LEN( @Field) - CHARINDEX('~', @field, charindex('~', @field)+1) -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
September 2, 2010 at 2:53 pm
Quite possible. Here's the rule:
If you remove the alias in the FROM clause (it looks like [Sheet$1] AS xl or just [Sheet$1] xl) then you need to reference 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
September 2, 2010 at 2:34 pm
WHERE T.Value > 0 OR T.Value IS NULL
Or:
WHERE ISNULL( T.Value, 1) > 0
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
September 2, 2010 at 2:31 pm
Near the end:
WHERE TestTable.ID IS NULL;
Should be:
WHERE survey.ID IS NULL;
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
September 2, 2010 at 2:24 pm
Heh, just borrow Wayne's Avatar?
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
September 2, 2010 at 2:20 pm
Please post the FROM clauses, it sounds like the old version of:
FROM dbo.TestTable survey
JOIN dbo.[Sheet1$] xl
...
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
September 2, 2010 at 2:19 pm
Pull the comma off the end of this line:
[STATE] = xl.[STATE],
Should be:
[STATE] = xl.[STATE]
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
September 2, 2010 at 2:17 pm
WayneS (9/1/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
September 1, 2010 at 9:22 pm
WayneS (9/1/2010)
No problem.
At least is doesn't "end up tripping on the leap year for multiple year scenarios."
True, but neither does the mm one, just gotta deal with that stupid 'in...
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
September 1, 2010 at 8:56 pm
Hm, that tally table looks interesting, and I'll explore it more shortly, I'm not immediately familiar with it. The crossjoin computations seems like it takes a lot more passes...
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
September 1, 2010 at 8:48 pm
simflex-897410 (9/1/2010)
Craig,The data was just dumped from mainframe to a .txt file and I just imported it to sql server db.
Nasty. Alright, quick fix. First, back the table...
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
September 1, 2010 at 8:43 pm
Um, Sim? You've got badly related flat file data there... no wonder it doesn't work. Um, wow, where to start here.
First, google up normalization. Secondly you need...
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
September 1, 2010 at 7:32 pm
Viewing 15 posts - 5,656 through 5,670 (of 5,678 total)