You don't have to use replace - the string will be converted (implicitly) to an integer for comparison so any leading/trailing blanks will not affect that conversion.

You can...

You don't have to use replace - the string will be converted (implicitly) to an integer for comparison so any leading/trailing blanks will not affect that conversion.

You can also use...

Monday to Sunday would be good for me to consider a week. It would be great to see the first week of 2021 as week 1 with just one...

You can simplify those queries without using a sub-query.

SELECT DISTINCT 
       column1 
  INTO temp_Weekly_Event_Report
  FROM [SQLDatabase].[dbo].[Table] 
 WHERE...

You are correct. I was trying to make the point that an iso_week runs Monday to Sunday. If the OP wants something else, say Sunday to Saturday, then some...

Something like this?

Declare @minDate datetime
      , @maxDate datetime;

    Set @minDate = (Select min(t.doj) From dbo.Test t);   ...

Thanks, Passed this information on to the team.

We just made a connection to the database, with some struggles. But succeeded. Next problem. Although the table names were the same...

You'll have to include more details. What is "n and null"?

The ON clause is processed similar to how a WHERE clause, but it is done first. The joins and...

I guess I am not following - you still haven't explained why you need to EXECUTE AS.  What is it that requires the procedure to be executed in...

I guess I am not following - you still haven't explained why you need to EXECUTE AS.  What is it that requires the procedure to be executed in a different...

SQL Search provides a list of the procedures that match your string - you then have the ability to select the procedure in the list, click on a link that...

FWIW - Filestream allows for direct access to the files through a file share...so not sure why that wouldn't work.  But - it would be a significant amount of work.

You...

Further to that - if you are using something else...then move the file system stuff to its own procedure and use EXECUTE AS on that procedure.  You can create a...

Not that you have the time - but this sounds like something Filestream was designed to accomplish and probably would be the better option long term.

With that said - there...

Okay - let's take a step back...can you outline what you need to do with this procedure?  Maybe there is a better way to approach the problem.  This sounds like...