Give this a shot from within sqlcmd or osql....



EXEC sp_addumpdevice 'DISK', 'MyBackupToFTPland', 'DirectoryYouCanFTPFrom\backup.bak'

BACKUP DATABASE yourdatabase
TO MyBackupToFTPLand

It seems to be exactly what the original poster wanted. What exactly do you mean by 'its a static solution?' Wouldn't any query need to be recalculated every time to ensure accurate real time...

You want something like:

SELECT columnyouwant1,...,columnyouwantn, rowcount = COUNT(B.ForeignKey)
FROM TableB AS B
GROUPBY B.ForeignKey


Load that into a temporary table. lets call it T. ...