Viewing 15 posts - 2,956 through 2,970 (of 5,678 total)
Grant Fritchey (6/20/2011)
Jayanth_Kurup (6/20/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
June 20, 2011 at 4:49 pm
[rant]
AAARRRGGGHHH....
One more person, just one more, who applies for an SSIS position (it's specifically advertised as an SSIS position) who's done nothing more than use it as a cross-server source/destination...
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 20, 2011 at 4:44 pm
jarid.lawson (6/20/2011)
I'm more curious how to get the logic to work in something like this. It is frustrating me because I can't think of it yet.
Why not just:
UPDATE Working_PIS SET...
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 20, 2011 at 3:59 pm
Errrrm, not sure why you'd want a while loop/Tally table at all here.
This code will return what you need:
select
( AccountBalance * CONVERT( Money, PosNegSwitch + '1')) AS AcctBal
FROM
#WorkingTable
TallyTable/WhileLoop is usually...
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 20, 2011 at 3:53 pm
That's a really odd percentage result calculation. What are you trying to get at in English? The math seems kinda wonky to me.
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 20, 2011 at 12:38 pm
bpowers (6/20/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
June 20, 2011 at 12:35 pm
opc.three (6/18/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
June 20, 2011 at 12:56 am
Well, if you just want a generic idea...
Account, Security, AmortizationCalculations, OutstandingLoans, etc...
What are you trying to do here? If you're looking for someone to hand you a built design...
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 17, 2011 at 12:16 pm
Roy Ernest (6/17/2011)
GilaMonster (6/17/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
June 17, 2011 at 12:04 pm
GilaMonster (6/17/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
June 17, 2011 at 11:43 am
GSquared (6/17/2011)
Craig Farrell (6/17/2011)
GSquared (6/16/2011)
Craig Farrell (6/15/2011)
Wait... then... who the heck is responding to me on the 1k+ posters board?Probably "The Thread" is.
Baaaah, I posted there at 200 points. ...
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 17, 2011 at 11:28 am
Phil Parkin (6/17/2011)
Actually, I was wondering about that. Does that mean the problem is that she has to get a full blow version of SQL Server to get the SSIS...
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 17, 2011 at 4:31 am
Opa! I haven't seen a homework question buzz by in a while.
It must be... 24 hours?
Woot!
Alright, let me ask you the first question, if the origination database and 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 17, 2011 at 4:22 am
WayneS (6/16/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
June 17, 2011 at 4:18 am
GSquared (6/16/2011)
Craig Farrell (6/15/2011)
Wait... then... who the heck is responding to me on the 1k+ posters board?Probably "The Thread" is.
Baaaah, I posted there at 200 points. I'm just that...
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 17, 2011 at 4:14 am
Viewing 15 posts - 2,956 through 2,970 (of 5,678 total)