lol Me too! But it's got great documentation: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-ver15

Is the linked server also SQL Server? If it is, you can do it without OPENQUERY(). You just need to  use the full name of the table "LINKED_SERVER"."DATABASE"."schema"."TABLE".

And why don't...

• This reply was modified 3 years, 10 months ago by  eduardoalmeidabr.
• This reply was modified 3 years, 10 months ago by  eduardoalmeidabr.

So, I had to redo my code because a dictionary wouldn't do it. I needed in fact a DataTable object.

I added two variables to my script task (path to the...

I followed the ideia given by Mr. Jeffrey Williams and now I have a collection of files in a dictionary ordered by value (date):

using System.Linq;
using System.IO;
using System.Collections.Generic;


public...

You're awesome! Thank you very much for your time and helpful comments and for your amazing answer on my question. I was really struggling with this one.

Wow! That's it! Sorry If I'm asking too much, but would you mind explaining what you did in the recursive part of the CTE? I'm really surprised by the result....