True enough, Brandie!

CREATE TABLE #BaseData(ClientNo int, Code varchar(3))

INSERT INTO #BaseData(ClientNo, Code)

VALUES

(123,'AAL')

,(1234,'AAC')

,(123,'AAC')

,(1234,'QPL')

SELECT * FROM #BaseData

CREATE TABLE #DesiredResult(ClientNo int, AAL varchar(3),AAC varchar(3),QPL varchar(3),)

INSERT INTO #DesiredResult(ClientNo, AAL, AAC, QPL)

VALUES

(123, 1,...

I forgot to write my setup:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86) Mar 29 2009 10:27:29 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition...

Hmm, how can I identify such an issue?

Here is some sample data in an attachment

Sorry for double post...

No ideas? I need to solve this one...

Well, they are not in the same schema, they are even in different databases. I did read the blog post but putting the view and the table in the same...