I've looked in to this a bit further and it appears that is might be an issue with our layer 3 switches.

A packet capture shows that the ARP announcements go...

As far as I am aware everything is configured on both nodes.

There are some occasions where failing the instances over works fine and then randomly it doesn't work again.

Occasionally I...

Thanks Phil, works perfect

Hi Scott, would there by a way of getting this to return all rows of TableA even if there are no matches in TableB or TableC?

I tried to change it...

• This reply was modified 2 years, 8 months ago by  MattNorman88.

Thanks Scott,

Does exactly what I wanted.

Apologies I simplified the data a little to make the example a little easier. I do required the ID's, these are the first columns in each of the tables.

The UsageCount...

• This reply was modified 2 years, 8 months ago by  MattNorman88.

Thanks, exactly what I needed

Something like this? (I may be oversimplifying something...)

-- exclude when phone # refers to multiple people.

-- exclude when phone # refers to multiple people.
SELECT * FROM...

If I am understanding your request properly, something like this should work, right:

WITH [cte]
AS
(
SELECT
[Mobile]
, [WorkTelephone]
, [HomeTelephone]
, [FirstName]
, [LastName]
, [PolicyNumber]
, COUNT(1) OVER (PARTITION BY
 [Mobile]
 , [FirstName]
...

I would want the first two rows returned as...

Hi Phil,

Thanks for the reply.

The create/ insert would be as follows:

CREATE TABLE CustomerPolicies
(
[Mobile] NVARCHAR(20),
[WorkTelephone] NVARCHAR(20),
[HomeTelephone] NVARCHAR(20),
[FirstName] NVARCHAR(30),
[LastName] NVARCHAR(30),
[PolicyNumber] INT
)

INSERT INTO CustomerPolicies VALUES ('07972234564', 'N/A', 'N/A', 'Jon', 'Evans',...

Perfect, that's now working.

Appreciate the help

SET @Query1 = FORMATMESSAGE(N'''SELECT SUM([master].[sys].[master_files].)*8/1024 FROM [master].[sys].[master_files] WHERE [master].[sys].[master_files].[name] = ''''%s''''', @DatabaseName)
SET @Query2 = FORMATMESSAGE(N'SELECT * FROM OPENQUERY([%s],%s'')', @LinkedServerName, @Query1)

Formatted it is:

SELECT * FROM...

• This reply was modified 5 years, 4 months ago by  MattNorman88.

Thank you Sue.

That was indeed the issue