Viewing 15 posts - 3,796 through 3,810 (of 5,678 total)
This would usually be done via T-SQL, or the reporting layer, not in SSIS. You could probably do it via a series of lookup functions and secondary queries, 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
March 7, 2011 at 12:02 pm
Rog Saber (3/7/2011)
However, just running the primary select statment just then took me 1:17 to return 14,765 rows. BUt, again, am I barking up the wrong tree...
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
March 7, 2011 at 11:45 am
To know what you want to look for, you need to know what you're trying to find. What details can you provide about your current issue that you're trying...
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
March 7, 2011 at 11:20 am
Without DDL and sample data like you'll find in the first link in my sig, best I can offer is general advice.
What you'll want to do is generate a query...
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
March 7, 2011 at 11:10 am
Rich, I'm pretty sure you'll definately need to self-join this for the final requirements.
You're looking for something similar to the following. Note, I'm not sure if you want to see...
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
March 7, 2011 at 11:05 am
Rog Saber (3/7/2011)
CREATE VIEW [dbo].[RTV_CURRENT_TRIP] (car_init, car_no, maxRTTRIPshipdatetime)
WITH SCHEMABINDING
AS
SELECT RT_TRIP.car_init, RT_TRIP.car_no, max(RT_TRIP.ship_date_time) maxRTTRIPshipdatetime
FROM dbo.RT_TRIP
GROUP BY RT_TRIP.car_init,
RT_TRIP.car_no
But I get an error when trying 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
March 7, 2011 at 10:38 am
Can you give us the specific command or statement that Service Broker is choking on, and any exact errors you may have encountered?
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
March 7, 2011 at 10:19 am
Had a rock in my craw I was doing this wrong, and I was. It certainly wasn't robust enough to handle interleaving the dates properly. I was sorting...
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
March 6, 2011 at 11:27 pm
Good Point Lynn. I had to doublecheck myself about 5 times to make sure I didn't screw up the results. 😉 (Comment edited because it made no sense out...
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
March 6, 2011 at 10:28 pm
Okay, figured out one way to do it, using neither of the methods I mentioned. Maybe someone else will have better luck with that. However, here's a solution...
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
March 6, 2011 at 9:18 pm
kadeshara (3/6/2011)
Hi Craig,Sorry about that, below sample code.
Perfect, and don't worry about it. You're new, we won't keelhaul ya for it. 🙂
I figured you weren't in 2k, glad 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
March 6, 2011 at 9:00 pm
This shouldn't be too bad, but it helps a lot to see the schema and sample data... especially in this case, as we can't easily see the grouping mechanisms.
Can 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
March 6, 2011 at 8:00 pm
Would need to see the execution plan to help you on that one. You might try also checking waits on the spid while it runs to see if 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
March 6, 2011 at 12:49 am
I haven't seen the problem before but have you tried the easy button of rebuilding the linked server and/or view to force a refresh of any metadata it may think...
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
March 6, 2011 at 12:44 am
Personal rule of thumb, which is subject to any number of exceptions:
I'll swap to a #tmp when I desire two or more indexes on the same temp table or at...
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
March 6, 2011 at 12:42 am
Viewing 15 posts - 3,796 through 3,810 (of 5,678 total)