Actually, the email system in SQL Server is quite robust and a copy of every email is stored in the msdb.dbo.sysmail_allitems table.  In fact, it's a bit of a pain...

That would be an rCTE (Recursive CTE).  If the recursion in based on incremental values and RBAR proceessing, a well written WHILE Loop  will be faster and less resource intensive.

Actually, there are 3.  The first one starts right after the word...

WITH SubQuery AS
(
SELECTjh.Company, jh.JobNum, ja.AssemblySeq, jo.OprSeq, jo.OpCode, 
            CAST(CASE WHEN NOT jh.Date03 IS NULL THEN...

I do appreciate all of the feedback.  However, you are fussing at the DBA who is the low man on the totem pole.  AVPs and managers have already made...

To be honest, this sounds like a case of the bad type of parameter sniffing.

I didn't read it that way so went back and read it again... and, yeah... I agree... you might...

You...

I've found that the biggest reason for SQLProfiler not capturing items is someone writing the wrong filter.

Heh... I make mistakes of that nature prior to having at least 2 full 12 oz mugs of coffee.  That means it's been happening a whole lot to me lately...

This wasn't someone posting a question.  This site allows folks...

Since SSIS is not SQL - it isn't the same - and the code is not processed as SQL code. Since the data is in the file - you...

Go back to your first post... see that cursor definition you posted?  Yeah... we need to know what you're trying to do with the data that cursor gathers.  We don't...

Here is a little different take on the solution:

 Select [Code]        = ltrim(substring(v.Item, 1, p01.pos - 2))
  ...

Similar to the accepted solution but without the common table expression.  It appears Jeff began to code it one way and then switched

select max(case when sp2.ItemNumber=1...