Try this:-

--Modified Bottom Select

SELECT

APP.ClientID,

APP.ReferralNumber,

APP.AppointmentDate,

ActualTime,

OneOfMissingRows = CASE WHEN f.Sequenceid IS NULL THEN 1 ELSE 0 END

--,GenHCPCode,RT.TeamCode,RT.SequenceID--,Count(*)

FROM dbo.vwBRSAppointmentsNPD As APP

LEFT OUTER JOIN SchemaBRS.AmsReferralTeam As RT on APP.ClientID=RT.ClientID and APP.ReferralNumber=RT.ReferralID

LEFT JOIN (

SELECT Sequenceid,...

Cast your IMAGE column to VARBINARY(MAX), which is compatible with DISTINCT and ROW_NUMBER().

See also http://msdn.microsoft.com/en-us/library/ms187993.aspx

Feature-packed and very readable article as always Paul.

It's a little like watching your favourite tv program - just as you're really getting into it, you reach the end and the...

Nope, it's an unsupported use of variable assignment which yields unpredictable results and has already been covered on the forum here.

The examples...

It's looking promising. I'd like to hear a few opinions from others first.

There's more:

DECLARE @s1 varchar(10), @s2 varchar(10)

-- '10__Jack'

SET @s1 = '10__'

SELECT @s1 = @s1 + Name--, @s2 = 'x'

FROM (SELECT ID = 1, Name = CAST('Sam' AS VARCHAR(10)) UNION ALL...

It doesn't look right to me either. Check these out:

DECLARE @s1 varchar(10), @Name1...

ColdCoffee (9/6/2010)

---

Chris Morris-439714 (9/6/2010)

---

Try this, CC:

--SQL 3(use 2 variable together,the same results)

SELECT @s1 = '10_45', @s2 = '20_45'

SELECT @s1 = @s1 + NAME--, @s2 = @s2 + NAME...

Try this, CC:

--SQL 3(use 2 variable together,the same results)

SELECT @s1 = '10_45', @s2 = '20_45'

SELECT @s1 = @s1 + NAME--, @s2 = @s2 + NAME

FROM ( SELECT...

Must be monday morning effect...

What exactly do you find strange?

-- create a sample table, correcting typos in column names and values

DROP TABLE #Rose

CREATE TABLE #Rose (Branchname VARCHAR(20), [status] CHAR(1), amount INT)

INSERT INTO #Rose (Branchname, [status], amount)

SELECT 'London', 'A', 100...

Read about sequential tables...

You have forgotten to describe the problem.

Here's some more helpful advice to go with Dave B's.

The part you are commenting out is a query which can be run in isolation from the rest of the query....