Lets break this down into sets.

You are combining two sets of data from this table:

1. All Product rows where [product_id] > 2
2. All Product rows where [product_id] is 1 or...

DATEDIFF() returns an integer value. DATEADD() returns a date value. You can't subtract a date from a number. You can do decimal math on datetime values, though.

SELECT DATEDIFF(week, (GETDATE() -...

-- Note: the schema name is declared and used outside of dynamic SQL

CREATE TABLE [dbo].[ChannelReading_940860_11_34216228-4C4A-4137-AEA5-EFA9D6A88364_MainLevelData]

-- but the schema name is not declared or used in dynamic SQL

declare @MainLevelDataTableName NVARCHAR(200) =...

You can use the OVER() clause with almost any aggregate function, not just windowed functions like ROW_NUMBER() and RANK().

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver15

That allows you to add in the column that SUM()s over a...

You have a list of all Orders that have at least one of three Items included.

You wish to exclude all Orders that have an Item that is not one of...

If you were not capturing it at the time, then that data is lost.

But if you were performing object-level changes on tables, you would have blocking - those changes require...

Is there a way to setup the listener so that it will listen for SQL2\MyInstance?

It's not supported; the command to create a listener accepts a DNS name. That doesn't mean...

• This reply was modified 3 years, 6 months ago by Eddie Wuerch. Reason: Typo on the port numbers

1 – How can I not use self-sign cert in the TDE encryption. If I am following the below steps/ commands, then I will be using self-sign cert with my...

SQL1 and SQL2 are presently identities in your domain. They have machine accounts and DNS entries. Creating a Listener with the same network name as another server on the network...

First, you're using full paths to the nodes, even though you've shredded them with the .nodes method:

SELECT xed.event_data.value('(/RingBufferTarget/event/data/value)[1]', 'nvarchar(500)') AS value1,

xed.event_data.value('(/RingBufferTarget/event/data/value)[4]', 'nvarchar(500)') AS value4

FROM #capture_tls_data

CROSS APPLY targetdata.nodes('//RingBufferTarget/event/data') AS xed (event_data);

The...

By default, what you're doing is not possible, because the way SQL Server performs encryption work changed in SQL Server 2017. You can work around this with a trace flag....

"My clients are web apps, and native mobile apps, goes via an APP server that talk to the DB"

You seem to understand it. The key point is that the value...

The difference between Developer Edition and Enterprise Edition is basically limited to licensing and what words display with SELECT @@VERSION. Anything you can do with Developer Edition will work in...

'19 Nov 2022' is converts to the datetime value of '19 Nov 2022 00:00:00.000', which is earlier (less than) '19 Nov 2022 15:19:12.000'.

Try:

WHERE [...]
AND CONVERT(date, TransferredDate) BETWEEN...

This is known as a "Data Islands" problem - you're looking for groups of records in an ordered set.

You have a identity value on the table, so this gets easy....