This forum is for MySQL. an open source SQL server. This post belongs in the MS SQL forum. They will have your answer. But you could try sqlcmd if the command line doesn't scare you. It should...

Please post the results. I am curious too see which is fastest. thanks

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



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

BACKUP DATABASE yourdatabase
TO MyBackupToFTPLand

Cursors are slooowwwwwww. you can add the ON DELETE CASCADE option to the foreign key in the sale_detail and sale_address tables. This makes it so that whenever you delete an entry in the parent...

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. ...