You need to provide an alias for the derived table in the query:

  from (select T0.ID,T1.SID,[dbo].[Planning](T1.Id,T0.SId) as Status
        ...

Instead of migrating, I'd just restore the database 6 times under 6 different names, then drop what isn't needed from each of them.

If you have foreign key constraints between tables...

Certification is a learning path that forces you out of your comfort zone.When I see someone with certs on their resume, I at least know they tried to get out...

If the connection's setting for CONCAT_NULL_YIELDS_NULL is ON (which must often be set to ON depending on use of other features), then adding a NULL string to a value string...

The problem with using IP address alone is that there's no indication that you wish to connect to the specific \SQLSRVR2008 instance.

If you set the IP port number for the...

Wrap the value of "riskDataRepeating" with braces (" { } ") instead of brackets (" [ ] "):

DECLARE @J2 NVARCHAR(MAX)

SET @J2 = '{
"riskDataRepeating": {
"TEST": [
{
"riskDataItem": {
"dataId": 123,
"label":...

The Serial value and the Queue name are both children of the queue nodes. Just use the path to the Serial value.

SELECT doc1.col.value('(@id)[1]', 'varchar(64)')   ...

SQL Server 2017 Developer Edition: https://go.microsoft.com/fwlink/?linkid=853016

That download is a small file; running it lets you choose to install directly or download the installation media.

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...

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 2 years, 9 months ago by  Eddie Wuerch. Reason: Typo on the port numbers