SELECT TOP og DISITINCT problem?

Måske da.. kan du ikke poste hele dit statement her :) For det lyder lidt underligt...

Hej

Sure thing...

--------------------------------------------------

SELECT TOP 25 u.[Id], p.[DisplayName], h.[Country],
  (SELECT COUNT(*) FROM [dbo].[UserRelations] WHERE [SourceId] = u.[Id]) As 'RelationsCount',
c.[SourceId], c.[DestinationId]               
FROM [dbo].[Users] u
INNER JOIN [dbo].[UserRelations] c
ON c.[SourceId] = u.[Id]
INNER JOIN [dbo].[Profile] p
ON p.[UserId] = u.[Id]       
INNER JOIN [dbo].[Headline] h
ON h.[UserId] = u.[Id]
WHERE h.[CultureId] = p.[PrimaryLanguageId]
ORDER BY u.[Id] DESC;

--------------------------------------------------

:-)

Jeg kan ikke se DISTINCT ?

nej den har jeg så fjernet, men den var her...

SELECT TOP 25 DISTINCT u.[Id], p.[DisplayName], h.[Country],

Men det virker ikke.

DISTINCT skal før TOP. Den her skulle virke:

SELECT DISTINCT TOP 25 u.[Id], p.[DisplayName], h.[Country],
  (SELECT COUNT(*) FROM [dbo].[UserRelations] WHERE [SourceId] = u.[Id]) As 'RelationsCount',
c.[SourceId], c.[DestinationId]             
FROM [dbo].[Users] u
INNER JOIN [dbo].[UserRelations] c
ON c.[SourceId] = u.[Id]
INNER JOIN [dbo].[Profile] p
ON p.[UserId] = u.[Id]     
INNER JOIN [dbo].[Headline] h
ON h.[UserId] = u.[Id]
WHERE h.[CultureId] = p.[PrimaryLanguageId]
ORDER BY u.[Id] DESC;