|
|
-
|
|
Often we come across situation where we need to group data from
multiple rows into single row. E.g.: An Employee works for multiple
projects, so in this case if columns are EMPLOYEE_NAME,
PROJECT_DURATION, PROJECTS_WORKED and think that employee works for 10
projects. Then you would have 1......
|
|
-
|
|
Purging your MSDB Job History is sometime very important which helps you read the Jos history in GUI very easily and keeps which only required number of days. You can add this in your Maintenance Plan or using a SSIS Package. I found one of the way a Stored Procedure to do the same. This Procedure a......
|
|