Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-01 : 08:38:36
|
| Michael writes "Two tables have a common collums called media_set_id. (See backupmediafamily & backupset of SQL*Server installation.) I want to return the machine_name, server_name, database_name, type from the backupset table BUT ALSO need the physical_device_name from backupmediafamily table. Trying to produce a generalised query that can query each SQL*Server installation, get the MAXIMUM backup_finish_date for BOTH datafiles AND logfiles (types D &L)and report the physical device written to..." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-01 : 13:57:45
|
| How far did you get on the query? Show us what you have and we'll fix it up so that it produces the results that you are looking for. We aren't just going to write the whole thing for you.Tara |
 |
|
|
|
|
|
Aggregate function return set join