I have an existing select query in reporting services that returns Jobs that have Joblines. The Jobline may have a DateCompleted set. What i'd like to do is return all Joblines within the Job if one or more DateCompleted's are set, if that makes sense ?
Sorry for the description, it's all part of being a novice ;-)
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…