With @year being defined as an Integer rather than a datetime.

If you are running some SQL which returns a result set of T-SQL queries, the answer is yes.

Return the result set to an Object variable, which should be shredded within...

• This reply was modified 6 years, 7 months ago by Phil Parkin. Reason: Fix typos

So you want an expression which returns a datetime of 5pm last Friday, is that it?

Your expression returns a datetime, as can be seen below:

"Also 2) i want to find last friday until 3 pm." This makes no sense to me, can...

• This reply was modified 6 years, 7 months ago by Phil Parkin. Reason: Additional text

When composing a query in SSMS, just drag from the 'Columns' node of the table you want (in Object Explorer) to SELECT from onto the editing window – SSMS will...

• This reply was modified 6 years, 7 months ago by Phil Parkin.

Like this?

WITH ExpiredDates
AS (SELECT m.CustomerID
          ,m.DateCreated
    FROM #MYTABLE m
    WHERE m.EntryType =...

• This reply was modified 6 years, 7 months ago by Phil Parkin.

Hi,   Thank for you confirming that, I did indeed search but wanted to clarify and see if anyone had a workaround. Sorry for troubling you. Have a good...

You cannot use the OPTION clause in views. See this link.

The SELECT clauses in a view definition cannot include the following:

• An ORDER BY clause, unless there is also...

Try this:

DROP TABLE IF EXISTS #Run;
DROP TABLE IF EXISTS #RunControlClient;
DROP TABLE IF EXISTS #SQLServerDatabase;

CREATE TABLE #Run
(
    RunID INT NOT NULL PRIMARY KEY CLUSTERED
 ...

Is this a many-to-many join?

P.Tracker_PSYH = Z.ZATS_PSYH

Who is this guy?

PS, the logouts happen to me too.

SSISDB is...

We can't see your tables or your data, so I'm not sure how you expect us to be able to refine your unformatted SQL.

Please post some consumable code, along with...

One obvious way is to disable the index & then rebuild it, once the update is complete. I presume you're trying to avoid that?

A general answer to what? You haven't asked a question.