SQL Select in oder Union Abfrage Optimierung mit Top

[NormanNG]

Hi,

ich meinte das so

SQL-Code:

SELECT     TOP (20) Feeder_ID, PU_NR, Sachnummer, Becker_SNR, Marry_Time, Computername, Linie
FROM         dbo.VW_History_Listen
WHERE     (Feeder_ID = 'KA0000383')
UNION ALL
SELECT     TOP (20) Feeder_ID, PU_NR, Sachnummer, Becker_SNR, Marry_Time, Computername, Linie
FROM         dbo.VW_History_Listen AS VW_History_Listen_42
WHERE     (Feeder_ID = 'KA0000385')
UNION ALL
SELECT     TOP (20) Feeder_ID, PU_NR, Sachnummer, Becker_SNR, Marry_Time, Computername, Linie
FROM         dbo.VW_History_Listen AS VW_History_Listen_41
WHERE     (Feeder_ID = 'KA0000387')