SSIS does not handle this scenario very well without code. The way I would do it is as follows:

• Set up a dataflow to read every row of the source...

Your problem here is that the underscore character is itself a wildcard in T-SQL, matching any single character. That explains the results you are seeing.

The solution is to ESCAPE the...

• This reply was modified 5 years, 2 months ago by Phil Parkin.

...it states that there are security implications to using it.

Not quite. It mentions 'potential security implications' – and Jeff has described some of those already.

• This reply was modified 5 years, 2 months ago by Phil Parkin.

No. Only Datetimes and NULL.

It may not be the case here, but spaces in path names are often problematic. Are you enclosing the path in quotes?

I'm also interested in knowing why you are trying...

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, 3 months ago by Phil Parkin. Reason: Fix typo