Well done. xp_cmdshell() would have allowed you to do this in your proc, of course.

A certain Mr Jeff Moden will probably tell you that the controlled enabling of xp_cmdshell poses...

You can easily do this using SSIS.

This is untested, as I don't currently have access to SQL Server, but should work OK:

SELECT DateDiff (Day,DateCalc.MyDateTime1,DateCalc.MyDateTime2) AS 'MyTimeSpent'
FROM sometable t1
CROSS APPLY (SELECT MyDateTime1=CAST(t1.Date1 AS DATETIME)...

I guess I'm an odd ol' duck.  I don't need or even want F2F interaction with humans unless it's on a pool table in my favorite bar and that's...

Will the MAX column be the same for every row of data returned, or are you looking for some sort of grouping?

What application or database are you trying to make this work in?

What do you mean by MSSQL? T-SQL is MSSQL, as far as I know.

I currently have nothing to test this with. What happens if you pass that value to your function?

Which part of this do you need assistance with?

There's something about one or more items...

• This reply was modified 5 years, 1 months ago by Phil Parkin. Reason: Fix typo

I've got 2 Project Variables which I use to control wether a package should run or not through the Disable Package Expression

I don't have SSIS in front of me right...

Can you show us the T-SQL which generated the error, along with the data which caused it? Also, what would your ideal solution be? Return NULL instead, with no error?

Not 100% sure about this, but please try it:

DROP TABLE IF EXISTS #temp_usage;

CREATE TABLE #temp_usage
(
    location_id INT
   ,item_id VARCHAR(40)
   ,PERIOD...

Was the 300GB comprised of data which has since been deleted, or just space?

Those backup destinations are local (to the server) drives only, and I'm not sure whether that can be changed.

But you should be able to perform the backup to your network...