I found the answer. What I had done was assigned the value to the variable in the Expression of the variable.
@[User::vETLMinimumStartDate] = (DT_WSTR, 50) (DT_DBDATE) DATEADD(...

Of course I should do that. I guess that what happens when I spend too much time converting PL SQL… and now back to your regularly scheduled cursor.

Phil,

I changed the procedure to create the index after the initial insert, but I had to immediately change it back. The while loop is controlled by @@ROWCOUNT. When the...

Phil,

In normal processing, I completely agree with you on loading the table and then creating an index. However in this case, there is an n-level recursion inserting data from the...

Phil,

I totally agree with points 3 & 4. With points 1 & 5, they are crucial to handle the recursion efficiently as coded. As for point 2, since this will...

Here is the call:

EXEC [MRP].[GetLoadMaster] --WITH RECOMPILE

WITH RESULT SETS

(

(

[MODEL_SN] [varchar](255) NULL,

[QTY] [numeric](12, 3) NULL,

[PARENT_ORDER_ID] [varchar](255) NULL,

[PARENT_PART_ID] [varchar](255) NULL,

[ORDER_ID] [varchar](255) NULL,

[LINE_NUMBER] [int] NULL,

[PART_ID] [varchar](255) NULL,

[PART_TYPE] [varchar](255) NULL,

[LOG] [varchar](255) NULL,

[PHASE] [varchar](3)...

CREATE PROCEDURE [MRP].[GetLoadMaster]

AS

BEGIN

SET NOCOUNT ON;

CREATE TABLE #RESULTS (

[MODEL_SN] [varchar](255) NULL,

[QTY] [numeric](12, 3) NULL,

[PARENT_ORDER_ID] [varchar](255) NULL,

[PARENT_PART_ID] [varchar](255) NULL,

[ORDER_ID] [varchar](255) NULL,

[LINE_NUMBER] [int] NULL,

[PART_ID] [varchar](255) NULL,

[PART_TYPE] [varchar](255) NULL,

[LOG] [varchar](255) NULL,

[PHASE] [varchar](3) NULL,

[LOG_JOIN] [varchar](255)...

Great catch and it does now. I had forgot to add that in when I switched from function to procedure. However the same error message was generated. The big changes...

Phil,

I had not known about WITH RESULTS SETS. Thank you.

As luck would have it, the next road block popped up.

When I execute the Procedure without the added WITH clause, I...

I think that Steve Martin said it best:

If I had one wish that I could wish this holiday season, it would be for all the children of the world to...

An exponential advance in technology is an understatement. Think of how far we come in just the last 50 years or even five years. Think about how young this World...

You do bring up a good point about contractors being let go to save money. I would contend that if you were a contractor in the banking industry during the...

FTE does not always translate into more stability. The last three years has taught us that.

Furthermore, just because you have a contract does not mean that they do not...

I agree with the above comment and do what is best for you and your family.

That being said there are two ways to look at leaving a contract. First from...