Building off of Luis' excellent solution...
This:

-- Sample data, solution
DECLARE @samples TABLE (dob date);
INSERT @samples VALUES
('20161102'),('20150326'),('20150717'),('20140818'),('20120712'),('20121201'),('20120522');

-- Solution
SELECT dob,

Note the line in my signature about the best way to get help. Pictures aren't the easiest because we can't copy/paste from an image. 

That said, what you are...

Phil beat me to it. We need more/better sample data and clearer expected results.  Something like this for the sample data:

DECLARE @yourtable TABLE (id int,...

I still love this proc Lowell (I'm using your newest version of sp_GetDDLa). I know I've posted that in this thread before. I thought I'd take a moment to include...

I've interviewed at a couple places that offer this and drilled them pretty extensively about it. It seems like a good deal - you're going to be able to take...

I just started playing around with SQL 2017 and was enthusiastic about TRANSLATE and STRING_AGG. STRING_AGG is long overdue and performs a wee-bit better than using the FOR XML PATH('') method and...

You have a couple options, none of which are super simple. 

OPTION 1 - Edit in BIDS or SSDT
As already mentioned, you can open the maintenance plan with...

Eric's original solution did not address multiple instances of the same SSN-matching pattern but he fixed that. The only problem is when an SSN appears at the beginning or end...