mealworms

The source adapter can usually glean the result set metadata from nested SP calls, but it sometimes gets confused when there are several nestings and many selects within the called...

Where I work, everyone sits in a cubicle environment....executives and grunts allike. The only office is a shared office for HR for privacy.

SSIS Data Flows work off of pre-defined columns. Are you saying that the result set from the SP can change?

Your problem is that you've chosen to use the Execute SQL task in combination with an object type variable. Not good. To get the data into a flat...

PaulB-TheOneAndOnly (10/22/2010)

John Rowan (10/22/2010)The execution plan shows a clustered index scan and returned results in under a second. This tells us that you don't even need the non-clustered index...

I ran a test where I populated your table with 60 million rows. I made the com_id column the Primary Key and clustered it. I added a non-clustered...

Lo Sole Mio tonight.....

What does your SELECT statement look like?

No problem.

SELECT *

FROM@Table t1

INNER JOIN (

SELECT MAX(PTID) as LastPTID,

AcctNo

FROM@Table

GROUP BY AcctNo

) t2 ON t1.AcctNo = t2.AcctNo AND t1.PTID = t2.LastPTID

Your Primary Key should uniquely identify each row. I think you are confusing Primary Key with Clustered Index. You are using the IDENTITY property for your com_id which...

Brandie Tarvin (10/19/2010)

John Rowan (10/19/2010)

Isn't Durham downtown?

There's one on 10th or 13th... (10th, I think) when you're heading out of downtown and towards Bellevue....

Brandie Tarvin (10/19/2010)

Henry Doorly (sp) Zoo. Beautiful place.

Fontinelle Forest (for hiking)... Lots of huge parks in...

Let's see...things to do near Omaha.

1. Go to Denver

2. Go to Kansas City

3. Go to Chicago

4. Go to Minneapolis

Besides that, Omaha has an outstanding Zoo. It is supposed to...