If you right-click the table in SSMS then script the table as INSERT, then do the same again and script the tables as SELECT. Paste this SELECT statement at the...

Is the ID column an IDENTITY column?

The accessor of the cte always delivers the next value in the recursion.  #2 returns '2019-10-13' which is the next value after the inequality inside the cte.  It is...

I don't have access to a 2008 server, but maybe you could try it with...

Thanks Jonathan, nice function. Which versions of SQL Server it will work with? It doesn't seem to work on 2008R2. I replaced IIF with CASE but now getting this:

"WHERE crc.[value] < parms.end_dt" was not necessary at all so I deleted it.  Your function obviated that necessity.  I wrote that but then I pasted it in with the...

I'd be interested to know if the SSIS transforms perform any better or worse than well-written SQL scripts.

Thank you Jeff, that's a great compliment coming from someone as experienced as you.

Hi scdecade,

Thanks for the feedback, I'm glad you've found a use for the function.

I didn't use "drop if exists" as this is a feature that was only introduced in SQL...

So when dealing with data transformations at tables with 40-50GByte in size: is it recommended to use SSIS interal operators at all or should I go always for DB...

Thank you! So there shouldn't be an issue changing the data type of the columns on my end with importing the data of the Varchar(max) type that we receive...

You should find out what the max length is of any of the data currently on the database

SELECT MAX(LEN(Id))        ...

You could make a start by putting your current T-SQL code into Script controls in SSIS then it would work in exactly the same way it does now but would...

Jonathan, what do you mean by "you can just add a unique constraint or index to any column that should be unique?"  What is the purpose?  Putting a UK...

With one exception, all of the VARCHAR columns in that table are VARCHAR(MAX), which is a LOB datatype.  That's the first thing...