So, NotManyPoints, answer Noel are you?

I read your comments about things starting to work and thought you hadn't finished getting everything, sorry.

Why not add the updates to your SSIS package?

NotManyPoints (2/4/2009)

---

Ok right, so we are staying here then.

So I'm interested, for the first 6 years (can you give a rough time frame) so we can put that into context...

Oh, about moving this discussion elsewhere, why? This is the perfect thread to have this discussion.

I'd still like to see if the OP has learned anything from this thread....

Nothing to apologize for, but please, still give us the info I requested. If you are using a loop, it won't scale well. There is most likely a...

NotManyPoints (2/4/2009)

---

Thankyou for paraphrasing my own thoughts, don't know what I would have done.

I have not said a DBA should know everything (to the point of being proficient in every...

Then we could use the following: table DDL, sample data (as INSERT statements that can be cut, paste, and executed to load the tables), and the expected results based on...

(whispering..) I see high velocity pork chops....

Oh, I may as well extend that I shouldn't be a DBA because I have no knowledge regarding replication. Yes, I set it up once years and years ago...

Need a little more from you. The DDL for the table in the function, sample data for the table (as INSERT sttements that can be cut, paste, and executed...

Actually, you did when your comments...

Not the PeopleSoft Admin here, so forgive me, but what app, Finance or HR?

Please post your code. Based on your last post indicating you are trying to use a loop, there is most likely a better way to accomplish your task without...

Just curious (since we don't have the DDL for the tables, sample data for the tables, or expected results based on the sample data), what happens to your query if...