hmmm... I would probably use a Derived Column transformation:

(DT_NUMERIC,20,2)(REPLACE(REPLACE([EuropeanVarcharAmount],".",""),",","."))

or something like that...

An example of a Stored Procedure where an output parameter could be used would be where the caller request a dataset be returned based on some input parameters, but at...

One must apparently be very careful with certain words here. I posted a reply which I subsequently edited to include a comment about me a busing (one word) CROSS APPLY...

;WITH myTable AS (SELECT * FROM (VALUES ('3#5'),('8063#0018375'),('8063#018375'),('063#018375'),('063invalid018375')) X(AccountNumber)) 
SELECT 
t.AccountNumber, 
lrp.LeftMostAccountNumberPart,
lrp.RightMostAccountNumberPart,
fp.AdjustedAccountID
FROM myTable t
CROSS APPLY (
SELECT 
CHARINDEX('#', t.AccountNumber) AS sepPos, 
LEN(t.AccountNumber) AS accLen
) sp
CROSS APPLY (
SELECT 
RIGHT('0000'...

;WITH myTable AS (SELECT * FROM (VALUES ('3#5'),('8063#0018375'),('8063#018375'),('063#018375'),('063invalid018375')) X(AccountNumber)) 
SELECT 
t.AccountNumber, 
lrp.LeftMostAccountNumberPart,
lrp.RightMostAccountNumberPart,
fp.AdjustedAccountID
FROM myTable t
CROSS APPLY (
SELECT 
CHARINDEX('#', t.AccountNumber) AS sepPos, 
LEN(t.AccountNumber) AS accLen
) sp
CROSS APPLY (
SELECT 
RIGHT('0000'...

• This reply was modified 6 years, 2 months ago by kaj.
• This reply was modified 6 years, 2 months ago by kaj.
• This reply was modified 6 years, 2 months ago by kaj.
• This reply was modified 6 years, 2 months ago by kaj.

I'm guessing this has to do with the new  Cardinality Estimator that was introduced with SQL Server 2014.

We've seen some strange goings on with this feature if the statistics aren't...

Never done it, but if you have CLR enabled, you might be able to use that instead of the old VBScript functions.

https://sqlsunday.com/2013/03/03/web-requests-using-clr-proc/

Sorry, but your story comes accross more like one of bad management style than one about a team member behaving badly to disappointment over his role in a project.

An additional note:
If for some reason it is necessary to keep the two source datasets in separate sections within the combined dataset, one can add an Id for each one...

Yes, exactly, and that is probably where...

LEFT JOIN alone will not cut it. You'll...

@stix83
It is not really clear (to me at least) what you want to do. Some sample data and desired output would go a long way towards allowing us to...