Perhaps BCP from a LOB column to a file?

I don't know much about how they did it because I never get to see the code but the devs where I work only have 1 connection configuration for each...

Why not get rid of FLOAT as soon as possible by CAST'ing POWER to BIGINT ?

select NumericValue, conv_bigint.num
from #IntChange ic
     cross apply...

Thanks for the feedback, Stephen.  Heh... being an old dude, I can really sympathize with you on the bad data thing.  It's been a problem even without computers since I...

My bad. Apparently I did not submit my post last week thanking Ant-Green for his solution and assuring this is not for SSNs or any kind of PII data....

How? With the reworked code you posted above?

It's a funny thing, Y.B.  I was thinking like Yogi Berra as in "This sounds like Deja Vu all over again".  I was right.  We had nearly this identical discuss...

BWAAA-HAAAA!!!!  That seems to be an issue even today!

Agreed.  I was only reading what you quoted and that was my comment about Dynamic SQL.  I totally agree DDL should be in source control.  Sometimes, though, source control and...

That's true, Phil... but I don't keep the results of Dynamic SQL in source control.  I don't keep the code that gets stored in cache that I interrogate with my...

Now I'm truly humbled and seriously appreciative.  You've cited the very reason I wrote those... a different way of thinking.  Thank you so much for the taking the time to...

Sorry, Brandie... I'd be of no help in either area.  They decided a long time ago that our infrastructure team would take care of such things to help with the...

You didn't say what the result should be if it is tied, for example, 2F and 2M?  In that case, I went with 'FemaleMix', adjust that if you need...

Ron,

The following does the trick for me when I need to do such a thing.  Details are in the flower box.

Create   FUNCTION [dbo].[ShowLongString]
/**********************************************************************************************************************
 Purpose:
 Display...

I can't speak for Ron but sometimes it's necessary to see, for example, the full monty for dynamic SQL.