Using TOP with my query -- sql server reporting services

sql server reporting services : Using TOP with my query

Shan
6/12/2007 2:49:00 PM

I have the following query. It works great, but I would like to only pull
the TOP 10 Counts of the result. How can I accomplish this. Thanks for the
help.

SELECT DISTINCT FR_FIRM_1.CITY, COUNT(FR_FIRM_1.CITY) AS FIRMCITY
FROM FR_FIRM_1 INNER JOIN
MR_MEMBER_1 ON FR_FIRM_1.FIRM_CODE = MR_MEMBER_1.FIRM
WHERE (MR_MEMBER_1.BOARD_MEMBER = 'Y') AND (MR_MEMBER_1.MEMBER_CLASS =
'R' OR
MR_MEMBER_1.MEMBER_CLASS = 'RW' OR
MR_MEMBER_1.MEMBER_CLASS = 'DR' OR
MR_MEMBER_1.MEMBER_CLASS = 'DRW')
GROUP BY FR_FIRM_1.CITY

EMartinez
6/12/2007 4:46:46 PM

[quoted text, click to view]

This should work.
SELECT TOP 10 COUNT(FR_FIRM_1.CITY) AS FIRMCITY, DISTINCT
FR_FIRM_1.CITY
FROM FR_FIRM_1 INNER JOIN
MR_MEMBER_1 ON FR_FIRM_1.FIRM_CODE = MR_MEMBER_1.FIRM
WHERE (MR_MEMBER_1.BOARD_MEMBER = 'Y') AND
(MR_MEMBER_1.MEMBER_CLASS =
'R' OR
MR_MEMBER_1.MEMBER_CLASS = 'RW' OR
MR_MEMBER_1.MEMBER_CLASS = 'DR' OR
MR_MEMBER_1.MEMBER_CLASS = 'DRW')
GROUP BY FR_FIRM_1.CITY
ORDER BY COUNT(FR_FIRM_1.CITY) DESC

Regards,

Enrique Martinez
Sr. Software Consultant

Shan
6/12/2007 8:13:00 PM

Thanks a lot. It worked.

[quoted text, click to view]

EMartinez
6/13/2007 12:00:00 AM

[quoted text, click to view]

Glad I could be of assistance. Let me know if I can be of further
assistance.

Regards,

Enrique Martinez
Sr. Software Consultant

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn