... but is this command trying to execute SecureZip on the server and the error is saying the application is not installed on the SQL Server?

Precisely this.

I stated that your sample data did not include EmpId 480.

That statement was correct now and remains...

not supported by Microsoft and against licensing rules to install a Client only application on a server.

I found the following text here:

Besides the technical problems, you must also consider...

Hello everyone,

I am currently looking for a way to create Excel reports that include formulae (probably also Pivot tables and other stuff) from Reporting Services. Searching the web and...

Is there a reason for you thinking that tempdb is the best place for your new table? Why not put it into an existing User database instead? Or create a...

I do not know the answer, but out of interest, under what circumstances do you choose to use global temp tables in preference to 'normal' session-scoped temp tables?

Does drive E: exist on the SQL Server machine, or is it a mapped drive?

It will be difficult for anyone here to help you, based on this limited amount of information & the fact that we have no knowledge of what this RAD tool...

Welcome, but please note that this is a SQL Server forum, not an MS Access forum.

Having said that, if you are doing this coding totally within Access, it should be...

Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I found a solution on a site but am...

Blimey, I think I need to stop posting and see a doctor! For some reason, I thought that there was a need to maintain the original file extension.

It's not pretty, or fast, but it works:

SELECT
    dat.pth
,   path2 = STUFF(dat.pth, calc.pos2, calc.pos1 - calc.pos2, 'this')
FROM
(
    VALUES ('temp/a/g.txt')
...

OK. One simplified solution would be as follows:

1. Assume SessionDate is always the first of the month (so 2020-01-01 in my example above).
2. Calculate the number of days between the...

What do you mean by this?

If StartDate was 2018-12-31 and SessionDate was 2020_01, what would be your desired answer as the number of years between the two?