The splitter function is indeed a table-valued function, but that doesn't mean you have to use the results in a table.  You can use it in a view if you...

This will work, but I suspect it's not what you're looking for.  So are you going to share the business rules with us, or wait for us to get bored...

You just need a splitter function.  Take a look at this.

John

You should always use a universally recognised date format so that your query works in whatever environment you happen to run it.  And don't use string manipulations - they're slower...

Since you posted in a SQL 2012 forum, I assume this doesn't apply to you, but if you have SQL Server 2016 or later, you can use the sys.time_zone_info view.

I think Perry's right - it's to do with ownership chaining.  What results do you get from these two queries?

SELECT
name
,USER_NAME(principal_id) AS SchemaOwner
FROM sys.schemas

Vijay

Does this help?

John

Given that a query returns a result set, and you're looking for two result sets per server, this isn't really possible. Certainly it isn't easy - you're trying to...

That's going to depend on what your private database...

I suspect that anyone attempting to answer your "question" would type "SSIS move files" and "SSIS error handling" into their favourite search engine and see what comes back. However,...

OK, good luck. If your server isn't running any other applications or components such as Reporting Services, I'd consider increasing max server memory to 5 or 6 GB. ...