Just out of curiosity what happens if you pull all the data into local tables then try running the same two tests(with and without TOP 1000)?

Well based on your data assuming that EndTime will always have at least 1 not null value greater than the minimum time from Starttime,

SELECT Taskid, MIN(StartTime),...

What exactly is the the call to xp_cmdshell doing?  And are you by any chance getting any errors in the windows logs at the time?

I believe you're looking for something like this,

https://msdn.microsoft.com/en-us/library/ms188001.aspx

What do you plan to do with this random number?

Is this something like what you're looking for?

Select column one, column two from tableA

Where

tableA.columnone NOT IN (SELECT column_one FROM tableB)


Well you can do it in SQL, ALTER TABLE <TABLE NAME> ALTER <COLUMN NAME> int

Keep in mind you might very well have values in the table that can't...

There's nothing wrong with using SPROCS in SSIS, but you're correct if you have SSIS packages that aren't being used for anything more than a shell to schedule running a...