Viewing 15 posts - 601 through 615 (of 5,678 total)
joshwirt (6/20/2013)
Calculate the impact of each record to the “Average Selling Price” in the attached excel file.
Attached excel file? This sounds like homework or someone at the office asking...
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, 2013 at 5:43 pm
That error is typically the kerberos double-hop issue. RDC to the machine in question and try to use the linked server from the local SSMS. If it succeeds...
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, 2013 at 5:12 pm
SQL Injection works because it's sending down direct SQL commands against the interpreter. Because of the nature of it, SQL can't block it because it's meant to send legitimate batches...
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, 2013 at 3:42 pm
Sai Viswanath (6/19/2013)
Thanks for the comments, and here's the code that I could get from the SQL Server Profiler when I worked with a report. The tables its...
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, 2013 at 2:29 pm
There are a number of techniques to approach running totals in T-SQL, the most documented of which is the quirky update which is an article and long discussion afterwards 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
June 20, 2013 at 2:08 pm
Luck Lynn.
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 18, 2013 at 4:52 pm
Just got back from vacation, Cert, but you're still overthinking this.
First, do proc_1 and proc_2 have the same results? If not, you cannot 'switch' them in an OLEDB source....
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 18, 2013 at 4:44 pm
I believe you can (as of '05 you could). You have to do it manually though. It can only auto-generate from existing Relational Integrity rules. It's been...
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 13, 2013 at 5:25 pm
You have what's known as (among other things) a delimited list parameter. As you've noticed, you can't shove it into an IN, it breaks.
The easiest way to do 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
June 13, 2013 at 4:57 pm
I personally prefer Visio because I can get as detailed or as generic as I like. Also it's what I'm the most comfortable with.
ERWin is another heavily used application...
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 13, 2013 at 4:53 pm
SQLRNNR (6/13/2013)
S.O.M.
Hunh?
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 13, 2013 at 2:32 pm
SQLRNNR (6/13/2013)
The Dixie Flatline (6/13/2013)
I will explain...No, to explain will take too long. I will sum up.
The Nurse is on second.
The enemy's gait is down.
Huh?
If I've gotten 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 13, 2013 at 2:24 pm
Huh?
Well, first, you can't loop inside a select statement, so that's out. You CAN subquery, but I'm not sure that'll get you where you're trying to go... well, that's...
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 13, 2013 at 2:22 pm
If the enemy's gate is down, then why is the Stone Table in the clouds? That just has to break one of the three laws.
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 13, 2013 at 2:19 pm
If I'm understanding you correctly, you're running into a twofold problem. One of them you can't fix.
First, you cannot use a source in a dataflow that will change its...
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 13, 2013 at 2:18 pm
Viewing 15 posts - 601 through 615 (of 5,678 total)