There is a nice "Stairway" series about XML

Did you searched SSC for a split string article ?

"Tally OH! An Improved SQL 8K “CSV Splitter” Function"

Execute the sproc in PlanExplorer ( free tool ) to record its full execution plan en explore the marvels of that tool.

DEVOPS is a buzzword !!!!! Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO ! ... Multiple projects /...

Check Shutdown

DEVOPS is a buzzword !!!!!

Can anybody point me  a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO !

The only guideline you get is: "start small...

Why on earth would you use data type FLOAT ????  ( especially if smallint / tinyint ) would do !

Does it hold blobs ? ( of tables that reside in other filegroups TEXTIMAGE_ON yourtroubledfilegroup)

or indexes of tables/views that reside in other filegroups ?

• This reply was modified 2 years, 11 months ago by Johan Bijnens.

Generate your test code:

Select 'DECLARE @test VARCHAR(5) = ''€'';
SELECT convert(char(100),'''+name+''' ) AS DBCollation, @test collate ' + name + ' AS VarcharText;
GO
' SelectQueries
from fn_helpcollations()
where name like '%latin%'
order...

have a look at "SET options"

have a read at: "Encrypt a Column of Data"

Great example on how naming variables ( etc ) can be confusing and lead you totally out of focus

removed - you're talking SSIS ( I assumed SQL DB engine )

Sorry, Johan... I'm not sure how to take that.  To be sure, it wasn't meant as an insult to anyone (especially you).  You hit the nail on...

indeed, Jeff