I don't know that we know that it's Social Security Numbers in clear text, do we? We only know that the name of the column is SSN, I think. It...

This would return NULL if the SSN existed only in the third table (for example). Not what the OP requires, I believe.

Yes, well that's the question, isn't it? I wouldn't...

I shouldnt have a problem joining the tables but my main concern was when i get to the end and write the where filter clause do I have to ask...

• This reply was modified 5 years, 9 months ago by kaj.

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, 7 months ago by kaj.
• This reply was modified 6 years, 7 months ago by kaj.
• This reply was modified 6 years, 7 months ago by kaj.
• This reply was modified 6 years, 7 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...