The SQL Server service account must have permissions on that directory/file

https://www.sqlservercentral.com/forums/topic/operating-system-error-code-5access-is-denied

https://docs.microsoft.com/en-us/answers/questions/265195/cannot-bulk-load-because-the-file-could-not-be-ope.html

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-bulk-copy-error-8220-operating-system-error-code-5-access-is/ba-p/316231

Native SQL backups? Do you really have a data path of "C:\Program Files\Microsoft SQL Server\MSSQL12.OPUS\MSSQL\DATA\OPUSDATA\a488f2a0-564d-44ce-8e57-7d5425d5b798\c55b8372-9595-4dce-9b68-16f5f5466a44\00016be8-000001a9-0005"? (The guid directory names seem odd to me, but may be deliberate).

Does that directory contain...

Deleted

Please have a go at providing scripts instead of pictures, as previously requested.

Please provide create table scripts & insert scripts for sample data so that those trying to help you...

One problem does stand out in the snippet -- use of most functions in WHERE clauses or JOINS prevent sargability (ability to use indexes)

WHERE ABS(T2.CALL_PRICE - T2.PUT_PRICE)...

As was communicated in a previous post,  we don't know the definitions of the CTEs your referencing. Without DDL for all underlying tables/views, and the entire query, there is little...

So add Table1.YearId  to each of the 3 select statements and group by statements.

SELECT Table1.PlayerId,
       Table1.TeamId,
     ...

This is an unfortunately redundant design. Table2 appears to inherently contain everything in Table1 except TeamId.

You could insert using union all, one select per position --something like:

SELECT...

Frozen pork chop.

And the issue with from and join names was pointed out here also: https://www.sqlservercentral.com/forums/topic/procedure-expects-parameter#post-3964459

This appears to be one of at least four different posts about the same query. Are you...

Appears to be a variation on https://www.sqlservercentral.com/forums/topic/procedure-expects-parameter

How to post code problems

To avoid ambiguity, it's better to use columname >= startdatetime and columname < enddatetime -- 2021-04-01 would appear to be the enddatetime you want in your example (assuming you want...

You are selecting from [@IND_ORLS] & joining [@IND_RLS1], but there are no table-valued-parameters w/ those names and no table types of those names declared & populated in the procedure.  And...

You haven't posted your CTEs, just a query that appears to reference four CTEs (OPTION_LIST_NEAR_TERM_CTE, NEAR_TERM_STRIKE_MIN_MAX_CTE, TIME_CTE, & DISCOUNT_RATE_CTE), so we can't know either.

Can you post DDL for the tables...

"I have such tables

1) UDT_CKB_SNAPSHOT - list of different items and events (items on sale) some promotions etc

2) FCSTPERFSTATIC - Forecast

3) HISTWIDE_CHAIN - Actuals"

You are being asked to provide scripts that...