Have a look at LAG (Transact-SQL) and LEAD (Transact-SQL). Tone of these will be what you want (depending on where you want the data).

Your...

What you're looking at here is called ownership chaining. https://technet.microsoft.com/en-us/library/ms188676(v=sql.105).aspx

If a user executes an SP which has an owner of dbo, which inserts data into a...

Double post of https://www.sqlservercentral.com/Forums/1865933/stacked-chart-with-vertical-secondary-axis-series. Please only make one topic per question 🙂

You don't need to change the format of your dates in your SQL, change it in your presentation layer. SQL will always display dates in the format yyyy-MM-dd, as per...

The DB owner can do anything in their own database. That includes dropping it, so I would actually ask, does the application need the ability to do this?

As...

Very much thinking along the same lines.

If the SQL is simpl;y just deleting the top 10 (with no WHERE or ORDER BY clauses), then it's not even guaranteeing...

So what does it do? You said it's not working, not working how?

Quick question as well, why are you using a separate function to get the value of...

Ouch... Perhaps something...

Assuming your applications each use a different login/user then why not capture that in your trigger, that should point you in the right path.

What do the error messages display in the log? What is your script task doing? We need more detail. "Goes Wrong" means nothing.

Can you provide much more concise...

Something like this?
CREATE TABLE #EMP (EmpID CHAR(1),
                   MgrID CHAR(1));
GO

INSERT INTO #EMP
VALUES
('A',NULL),    
('B','A'),    
('C','B'),    
('D','C'),    

In very simplistic terms, I'd probably do something like this:
CREATE TABLE #Dates (StartDate DateTime, EndDate DateTime);

INSERT INTO #Dates (StartDate, EndDate)
VALUES ('20170428 15:00:00', '20170504 10:00:00');