Viewing 15 posts - 301 through 315 (of 3,232 total)
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...
October 25, 2010 at 10:34 am
Where I work, everyone sits in a cubicle environment....executives and grunts allike. The only office is a shared office for HR for privacy.
October 25, 2010 at 10:09 am
SSIS Data Flows work off of pre-defined columns. Are you saying that the result set from the SP can change?
October 22, 2010 at 3:14 pm
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...
October 22, 2010 at 3:06 pm
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...
October 22, 2010 at 12:59 pm
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...
October 22, 2010 at 12:15 pm
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
October 21, 2010 at 12:47 pm
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...
October 21, 2010 at 12:41 pm
Brandie Tarvin (10/19/2010)
John Rowan (10/19/2010)
The Railroad museum is the Durham Museum.
Isn't Durham downtown?
There's one on 10th or 13th... (10th, I think) when you're heading out of downtown and towards Bellevue....
October 19, 2010 at 11:26 am
Brandie Tarvin (10/19/2010)
John Rowan (10/19/2010)
Let's see...things to do near Omaha.Besides that, Omaha has an outstanding Zoo.
Henry Doorly (sp) Zoo. Beautiful place.
Fontinelle Forest (for hiking)... Lots of huge parks in...
October 19, 2010 at 10:38 am
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...
October 19, 2010 at 9:54 am
Viewing 15 posts - 301 through 315 (of 3,232 total)