You can use Windows Scripting to run DTExec on the SQL box, from the other box.

a)

select ownerfname, count(ownerid)

from house

group by ownerfname

having count(ownerid) > 1

Hi, you have two ways:

1. Get those members (100, 200...) from the fact table, as an aggregated level where 100 is the parent for 111, 123... This can be done by using...

Use the xp_cmdshell procedure to execute a DOS command. You can find lots of articles about this famous command.

Always export to the same Excel file, and then rename this file with a stored procedure to the name you wish.