SELECT Region_FK, CountyName
FROM County
ORDER BY Region_FK
COMPUTE COUNT(REgion_fk) BY Region_FK

Above query runs and display all rows and group in Query analyzer but It
displays only first group and its rows when I run in enterprise manager
table select and from DTS SQL to Excel.
Any idea please
Thank you
Zainul
Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


MS Sql Server LazyDBA home page