Viewing 15 posts - 301 through 315 (of 5,678 total)
Sean Lange (6/19/2014)
GF (6/19/2014)
The problem was user error.
There were in fact no duplicate but at the time I was certain there were.
I was at the end...
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, 2014 at 1:06 am
should work:
SELECT customer_id, CONVERT( INT, po_number), COUNT(*)
FROM customer_po_numbers
GROUP BY customer_id, CONVERT( INT, po_number)
HAVING COUNT(*) > 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
June 18, 2014 at 7:30 pm
Replace @testdata with your column name and you should be good to go.
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, 2014 at 7:28 pm
Like this?
DECLARE @testdata nVARCHAR(255)
SET @testdata = N'Update record GUID{1231jk-2322yy-2883487-dhe33}'
SELECT
SUBSTRING( @testdata, CHARINDEX( '{', @testdata) + 1, CHARINDEX( '}', @testdata) - CHARINDEX( '{', @testdata) - 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
June 18, 2014 at 7:03 pm
Are you looking for LTRIM/RTRIM for whitespace trimming, or some form of SUBSTRING() manipulation to grab the center of actual text? We'll need some more details to help 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
June 18, 2014 at 6:29 pm
autoexcrement (6/18/2014)
Sorry, guilty as charged. Was trying to limit the code to only the relevant bit. Is this better?
Well... better yes.
More understandable? Hrm. Hold that thought.
*wanders off...
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, 2014 at 6:28 pm
imani_technology (6/18/2014)
There are several sources of the data that will ultimately go into the star schema data warehouse.
What is the expectation for you moving the data twice? 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 18, 2014 at 6:17 pm
I have no idea how that could even run without an error stating T3 and T4 weren't defined.
If you yanked it out of context, it's probably something like this:
tblA
LEFT JOIN...
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, 2014 at 5:53 pm
This just dumped off the deep end from the original question.
Paraphrased, first question: "How do I snapshot replicate a database on another server the quickest and most effective way repeatedly?"
With...
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, 2014 at 5:20 pm
Grant Fritchey (6/18/2014)
Yeah, one guy offered to pay me, so I sent him my rate. And that was the end of that.
Heh, I don't mark up when someone tags 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 18, 2014 at 5:14 pm
The Configuration Table can't be used for detection because Configurations can be re-used between packages. You can't rely on it.
There's really no way around it, you have to either...
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, 2014 at 5:07 pm
A lot of smaller companies are trying to tighten their purse strings, thus the drive towards the open source items. The new tech is also nice and shiny.
DBD vs....
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, 2014 at 5:03 pm
Any chance one of y'all with inroads to the powers that be at RedGate could get someone to update the spam filters on the site for the duration of 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 16, 2014 at 12:33 pm
imani_technology (6/13/2014)
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, 2014 at 5:54 pm
Why does it matter?
I ask because a project for SSIS is basically just a container to allow for packages to be ran for debugging.
You *can* use shared Data Sources, but...
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, 2014 at 5:50 pm
Viewing 15 posts - 301 through 315 (of 5,678 total)