Quite few ways of doing this, here is one

😎

DECLARE @XML_STUFF TABLE

(

XML_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,XML_DATA...

The problem is in the data, each node can only have one parent!

😎

Quite few ways of doing this, in essence create a set of all customers/months and then do the count.

The server normally translates queries such as "select * from A left...

It is more of a preference, kind of a reminder...

Firstly, thank you all for looking into this. It was me after all missing something rather obvious, maybe too obvious. The CTE in the code generates a sequence of 10^8...

First thought would be a VPN implementation, encrypts the point to point communication

😎

Ooops, the lights are on but no one's at home 😛

[mental...

A little trick with SIGN and the OVER clause makes this a simple query

😎

USE AdventureWorks2012;

GO

;WITH MULTI_COUNTING AS

(

SELECT /* Sum the row numbers, gives distinct count */

...

IMHO: The ability to quickly hide and show the result pane is very helpful, especially when working with limited screen estate (laptops, tables & mobiles).

😎

What does this return?

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'MasterAgentPayments'

Do you have the duplicate table in a different schema?

😎

Next step, generate the create script for the table. Make certain to go first to tools->options and under SQL Object Explorer->Scripting select all the relative options.

Let us know what you...

Execute this statement (with the correct schema and table name)

EXEC sp_help 'schema.table'

Then look for the constraint and Foreign key reference sections. Resolve those!

😎

If it is not working then take a look at this: CTRL + R not working in SSMS 2012

😎

First thing that comes to mind is to use the SQL Server Import and Export Wizard from SSMS. (right click on the target sql database->Tasks->Import data) Walk through the Wizard...

For what it's worth, have a test system with 2005 and 2014 on it, not on the same drives though, 2005 is a default 1433 instance, 2014 a named instance,...