CREATE PROCEDURE MoveEmployeesFromManagerToManager @SourceManagerID INT, @DestinationManagerID INT AS DECLARE @RCount INT DECLARE @Output AS TABLE ( Msg NVARCHAR(MAX) ) BEGIN TRY INSERT INTO @Output VALUES( N’Moving employees from ManagerID ‘ + CONVERT(nvarchar(50), @SourceManagerID) + ‘ to ManagerID ‘ + CONVERT(nvarchar(50), @DestinationManagerID) + ‘…’ ) BEGIN TRANSACTION UPDATE Employees SET ManagerID = @DestinationManagerID OUTPUT N’Moved EmployeeID ‘ + CONVERT(nvarchar(50), INSERTED.EmployeeID) INTO @Output FROM HumanResources.Employee AS Employees … Continue reading Using Reporting Services as your Software Frontend