Viewing 15 posts - 2,116 through 2,130 (of 5,678 total)
Marios, you know how hard this is without sample data and schema to work from.
Are there identifiers that can be used to group these rows?
Basically, what you're looking to do...
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, 2011 at 1:04 pm
tarr94 (12/9/2011)
I guess the best way to describe my problem is by giving sample data.
Yep, but you'll want to make it consumable so we can provide you back tested code....
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, 2011 at 12:55 pm
mtassin (12/8/2011)
I did... that's where the dates and times from above come from. 🙂
D'oh, *facepalm*. Sorry.
I'm wondering if this is a case of SSIS complaining about the incorrect...
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, 2011 at 12:51 pm
rwsmith 38519 (12/9/2011)
Thanks! I really appreciate the help.
That works for the most part. It does number the units, except it skips the first one. Basically starting at 1 with second...
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, 2011 at 12:43 pm
call.copse (12/9/2011)
Evil Kraig F
As to a right to complain, I would disagree with that. Heck, I disagree with the removal of capital punishment, instead of a $0.15 bullet...
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, 2011 at 12:03 pm
Koen Verbeeck (12/9/2011)
Cadavre (12/9/2011)
Koen Verbeeck (12/9/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
December 9, 2011 at 2:38 am
andagr (12/9/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
December 9, 2011 at 2:35 am
Koen Verbeeck (12/9/2011)
IE, why u no easily let me delete cache? (without deleting cookies and saved passwords).(woohoo, 6000th point :w00t: :cool:)
Because Basement-Cat made IE.
I apparently need to post more 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 9, 2011 at 12:07 am
I personally do not want my job duties to be spelled out that completely. Most of the more interesting work I've done has been because someone dropped by my...
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, 2011 at 12:06 am
matt.newman (12/8/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
December 8, 2011 at 11:53 pm
It's a big topic and will require some research, but look into 'fuzzy lookup' in 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
December 8, 2011 at 3:15 pm
AndrewSQLDBA (12/8/2011)
After going over the results very closely, you are correct, and your initial code was perfect.
Not sure what I had seen that I thought was not correct.
I apologize 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, 2011 at 3:10 pm
Tony Palmeri (12/8/2011)
Steve Jones - SSC Editor (12/7/2011)
Tony Palmeri (12/6/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
December 8, 2011 at 3:05 pm
matt.newman (12/8/2011)
DataWareHouse database on separate Raid 1 volume.
Like living dangerously, I see? Might I recommend at least RAID5 so you can survive a single drive outage?
I intend to re-architect...
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, 2011 at 2:22 pm
DoubleEx (12/4/2011)
I find no local jobs running on this server to account for interference and trace is only showing me when the performance problem occurs.
Normally I would assume...
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, 2011 at 2:11 pm
Viewing 15 posts - 2,116 through 2,130 (of 5,678 total)