Update Syntax based off of a query

Hey Experts!

Trying to learn a bit about SQL for a project I'm working on.

I have a stored procedure (sp_TestEmployeeTimeRecordWithRate) which allows me to query a few tables and returns a calculated result called 'RecordBillTotal'.  This Query is perfect, however I would like to create a second stored procedure that will then take that 'RecordBillTotal' and place it into a column called TimeRecordBillTotal in a tabled called TimeRecord.

Over all Goal being is that our accountant could run the Stored Procedure based upon a set of values which then update a column in the origianl record.

I have pasted my current Stored Procedure below

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER Procedure [dbo].[sp_TestEmployeeTimeRecordWithRate]
@TimeRecName nchar(50), @TimeRecProjectNumber nchar (6)
AS
SELECT     TimeRecord.TimeRecEmployeeName, TimeRecord.TimeRecHours, TimeRecord.TimeRecProjectNumber, ProjectInformation.ProjectBillRateZoneName,
                      EmployeeInformation.EmployeeBillRateZone, TestBillRates.Rate, (TestBillRates.Rate * TimeRecord.TimeRecHours)AS RecordBillTotal
FROM         TestBillRates INNER JOIN
                      ProjectInformation ON TestBillRates.Zone = ProjectInformation.ProjectBillRateZoneName INNER JOIN
                      EmployeeInformation ON TestBillRates.EmployeeRate = EmployeeInformation.EmployeeBillRateZone INNER JOIN
                      TimeRecord ON EmployeeInformation.EmployeeName = TimeRecord.TimeRecEmployeeName AND
                      ProjectInformation.ProjectNumber = TimeRecord.TimeRecProjectNumber
WHERE TimeRecord.TimeRecEmployeeName = @TimeRecName AND TimeRecord.TimeRecProjectNumber = @TimeRecProjectNumber


Start Free Trial