teutales (12/9/2010)

---

So you are right - the agent is the correct task to do this. In SQL Express I do not have an agent - but the service broker is...

LutzM (12/8/2010)

---

Sorry for being imprecise... 😉

Right at the beginning of your *cough* c.u.r.s.o.r. you populate the WannaBeTempTable @DelPortList

I'd expand this table to hold the value for PortfolioCode, insert the...

Are you backing up locally, or to an unavailable file server?

With that data, you...

It's because ID one is repeated in your connection. What Update will do is update each row with each value, so first it sets it to the first instance...

Chrissy321 (12/8/2010)

---

Let me please amend this by saying I can use CTE since I am working in a 2005 environment but the proposed function would be referencing a linked 2000...

The quick and dirty solution is this:

Select *

From ProblemTicket

Where ( (ProbTicketDate Between @StartDate And @EndDate) OR (@StartDate IS NULL))

AND (ProbTicketSubName = @Submitter OR @Submitter IS NULL)

AND (ProbTicketAssigned = @Assigned OR...

LutzM (12/8/2010)

---

Correct me if I'm wrong but don't you have the value of s.securityID inside your ForEach loop container as an output value of filling the SecByBatch table? If so,...

Jack Corbett (12/8/2010)

---

I still haven't seen any valid excuses...

If y'all are under-qualified I don't what that makes me as one of the organizers. I'd say severely under-qualified.

BTW-the...

Well I'll be damned. I had to test it myself to be sure (you left the unique check flagged above, fyi) but you're right.

Alright, I take back what I...

LutzM (12/8/2010)

---

How do you populate the PortSecAgg_staging table?

Do you really need to update portfolioID and securityID for each and every row?

That basically means to join 36mill rows to 48mill rows...

Last question first:

Also is there a way to tell what records have been read from a table after the fact, maybe some way to use the execution plan? It...

Alvin Ramard (12/8/2010)

---

Jack Corbett (12/8/2010)

---

I still haven't seen any valid excuses...

If y'all are under-qualified I don't what that makes me as one of the organizers. I'd say severely under-qualified....

Ron's recommendation is probably your best method. However, if you want to do this in pure SSIS, you're going to be looking at using the MERGE JOIN structure to...

rstarr-916208 (12/8/2010)

---

Thanks Craig, Jeff for pointing out the inefficiency. I didn't realize that using the aggregation like that would be so slow.

On the other hand the original question was: "How...