"Component" is just an alias.  It's not a column of table b (VndrCmpntNum ).  Remove the "b." from the ORDER BY clause and it should work.

John

I think even the security update includes the CUs, but I wouldn't swear to that.  Might be safer to install the latest CU and then the security update.

John

Thanks Grant.  Yes, absolutely.  The only reason I specifically mentioned security updates was in response to the second question in the original post.

John

SP2+CU11 will include all security updates up to and including the date of release of CU11.

John

Yes, you can do it like that, or you could build the query dynamically, adding the WHERE clause only if the checkbox is ticked.

John

Where do all the currencies come from?  This page lists only 178, so you could use that as your basis, extend the query I posted earlier, and get a...

SELECT
     Entity
,    Account
,    MAX(CASE
            WHEN LocalCurrencyID = 'USD' THEN Amt
            ELSE 0
        END) AS USDAmount
,    MAX(CASE
            WHEN LocalCurrencyID = 'CAD' THEN Amt
            ELSE 0
        END) AS...

Sam

You could use dynamic SQL for this, but unless you're very careful, you'd be vulnerable to SQL injection.  Instead, I recommend that you use a splitter...

Yes, I agree.  Qualify all objects with schema names.  If that doesn't work, post the code.

My guess is that the schema name you've missed from your code is...

Why not put some debug logic in your stored procedure so that you can see what's taking the most time?

Here's what sticks out to me:
(1) No WHERE...

Have you tried TRY_CONVERT?

John

In the first CTE, you're testing whether the value can be converted to a numeric type (although ISNUMERIC isn't totally reliable, but that's another discussion).  In the second, you're just...