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 |
|
k_babb
Starting Member
2 Posts |
 Posted - 2014-02-04 : 08:55:42
|
| Hi i am new to sql i have created a powershell script to load some data into a tablei have servername, result, date as headings they are text,text anddatei want to select each severname where the result was successful but only one of each so for exampleif servername "test server" backup sucessfully twice i only want to return the latest date |
|
|
k_babb
Starting Member
2 Posts |
Posted - 2014-02-04 : 09:56:50
|
| Can i do something likeselect Distint servername where result like 'Success'and date(max date) |
 |
|
|
|
|
|
How to select the last sucessful backup