That makes sense.  I'm not sure what happened there, but this is helpful.  Thank you.

Jeff,

Yes, I saw that part about returning various numbers.  I think I might have misunderstood what is meant by the procedure generating an error.  I took that to mean if...

Jeff,

Thanks for the link.  Now I understand how to obtain the return code.

Here is the only part I don't understand.  Using the code from my example, how might the procedure...

• This reply was modified 4 years, 7 months ago by  michael.leach2015.

This makes sense.  When using the DELETE statement usually there is nothing following the delete, however you have the alias of the derived table, after DELETE.  If I omit do...

In looking back I guess there wasn't really a need to post the original data in the blue/green columns.  I understand it now.

Also, I'll keep in mind the suggestion about...

I have another problem that might be similar.  In the attached file to this post, the tab called Example 1G shows the query I used above the yellow columns.  The...

I forgot to take that into account.  That makes sense now.

I have a screenshot of the SQL code pasted into the Excel file.  Did you see the screenshot?

For the sample data, that is shown in the first table on both...

<li style="list-style-type: none;">

1. Nope. The multi-statement UDF is effectively a table variable. It lives within the context of the query it runs within. The in-line table function is...

That was going to be my exact...

That was going to be my exact question.... or...

You're UPDATE statement is incorrect.  If you are going to alias something, you need to use that alias throughout.

UPDATE o -- use the alias here.
SET o.Description...

To everybody.  It worked.  Thank you.

Or, put the CTE with the select that is calling it:

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)INSERT INTO ProductName...

you need to use the output clause

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)


INSERT INTO ProductName    ...