Viewing 15 posts - 4,651 through 4,665 (of 5,678 total)
teutales (12/9/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
December 9, 2010 at 1:38 am
LutzM (12/8/2010)
Right at the beginning of your *cough* c.u.r.s.o.r. you populate the WannaBeTempTable @DelPortList
I'd expand this table to hold the value for PortfolioCode, insert 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
December 8, 2010 at 11:05 pm
Are you backing up locally, or to an unavailable file server?
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
December 8, 2010 at 9:33 pm
rocky_498 (12/8/2010)
Thanks for your reply, How i can do one to one match and update in sql syntax ? Could you please post sql syntax for me?
With that data, you...
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
December 8, 2010 at 9:14 pm
It's because ID one is repeated in your connection. What Update will do is update each row with each value, so first it sets it to the first instance...
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
December 8, 2010 at 9:03 pm
Chrissy321 (12/8/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
December 8, 2010 at 9:01 pm
The quick and dirty solution is this:
Select *
From ProblemTicket
Where ( (ProbTicketDate Between @StartDate And @EndDate) OR (@StartDate IS NULL))
AND (ProbTicketSubName = @Submitter OR @Submitter IS NULL)
AND (ProbTicketAssigned = @Assigned OR...
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
December 8, 2010 at 7:25 pm
LutzM (12/8/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
December 8, 2010 at 5:34 pm
Jack Corbett (12/8/2010)
If y'all are under-qualified I don't what that makes me as one of the organizers. I'd say severely under-qualified.
BTW-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
December 8, 2010 at 5:26 pm
Well I'll be damned. I had to test it myself to be sure (you left the unique check flagged above, fyi) but you're right.
Alright, I take back 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
December 8, 2010 at 4:58 pm
LutzM (12/8/2010)
Do you really need to update portfolioID and securityID for each and every row?
That basically means to join 36mill rows to 48mill rows...
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
December 8, 2010 at 4:52 pm
Last question first:
Also is there a way to tell what records have been read from a table after the fact, maybe some way to use the execution plan? It...
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
December 8, 2010 at 4:21 pm
Alvin Ramard (12/8/2010)
Jack Corbett (12/8/2010)
If y'all are under-qualified I don't what that makes me as one of the organizers. I'd say severely under-qualified....
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
December 8, 2010 at 4:01 pm
Ron's recommendation is probably your best method. However, if you want to do this in pure SSIS, you're going to be looking at using the MERGE JOIN structure 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
December 8, 2010 at 3:53 pm
rstarr-916208 (12/8/2010)
On the other hand the original question was: "How...
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
December 8, 2010 at 3:46 pm
Viewing 15 posts - 4,651 through 4,665 (of 5,678 total)