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...

Rog Saber (3/7/2011)

---

Here are the indexes:

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...

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...

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...

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...

Rog Saber (3/7/2011)

---

Here's where I created the view OK:

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...

Can you give us the specific command or statement that Service Broker is choking on, and any exact errors you may have encountered?

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...

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...

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...

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...

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...

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...

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...

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...