Thanks, most helpful and the suggestion to include it in a sub-query makes the maintenance much easier.

Thanks again.

That worked! Thanks.

Hi Kingston,

Thanks for the reply. I believe that makes perfect sense.

As a teachable moment - how can I see the "Execution Plan"

If you remove the WHERE clause the ORDER BY works just fine.

I'll try your suggestion.

I just got back to this and you hit it on the head @breadcrumb needed to be initialized.

I tried that eariler without success.

I did discover that if I remove the concatenation then it will return the last crumb

SET @breadcrumb = '<a href="prodList.aspx?idCategory=' + CONVERT(NVARCHAR(6),@idCategory) +...

Note the PRINT statement prints the correct breadcrumb string.

I'm using the following EXEC

DECLARE@return_value int

DECLARE @BCrumb VARCHAR(2000)

EXEC@return_value = [dbo].[Category_GetCategoryPos]

@idCategory = 260,

@breadcrumb = @BCrumb OUTPUT ,

@links = 1;

SELECT @BCrumb as crumb

SELECT'Return Value' = @return_value

GO

crumb contains NULL

If...

This issue is not with SSMS but with the SP returning the output parameter to a C# program. SSMS displays the Print @breadcrumb with the breadcrumb but when...