Grant/VJ/Sam,

Thanks.

Bill

In this situation, I am the system designer/administrator/payroll person. so it falls to me.

Any thoughts on the other items?

Thanks,

Bill

Is the DB Normalized? I believe so. I’ve set up tables for Customer, Jobs and Clients (the workers) basic info along with new tables with related info,...

Jeff,

I only dropped the left @'s. The ones inside the coalesce are still there.

Thanks for the follow up.

Bill

G Squared,

Thanks. I dropped the @'s in the SET and it worked. It sure is great to have another set of knowlegable eyes to look at stuff.

Jeff,

I don't understand the...

When I use the following, it still doesn’t work

BEGIN TRY

IF EXISTS(

SELECT *

FROM

tbl_TimeSheetEntry

WHERE

@BatchNumber = tbl_TimeSheetEntry.BatchNumber

AND

@LocationNumber = tbl_TimeSheetEntry.LocationNumber

AND

@WorkDate = tbl_TimeSheetEntry.WorkDate

AND

@Client_PK_ID = tbl_TimeSheetEntry.Client_PK_ID

AND

@StepNumber_PK_ID = tbl_TimeSheetEntry.StepNumber_PK_ID

)

BEGIN

BEGIN TRANSACTION

UPDATE tbl_TimeSheetEntry

SET HoursWorked = coalesce(@HoursWorked, HoursWorked),

Units...

Adam/PW,

I had declared the @Client_PK_ID, I just wasn't putting it to use.

You guys are awesome! I'm going to print out this and other posts for reference. Hopefully it will begin...

Just changed

tbl_Clients_ClientBasicInformation.Client_PK_ID =

Client_PK_ID

to

tbl_Clients_ClientBasicInformation.ClientNumber =

@ClientNumber

and Wha-La! It (appears) to work!

Thanks,

Bill

The way the code is currently written below, if the desired/selected ClientNumber does NOT exist in the BasicInformation table, then the “SET @Message = 'Does Not Exist' happens, as...

Thanks guys.

I'm gonna take a break and eat some dinner. Maybe my sub-conscious will work on it for a while.

I'll get there.

Thanks,

Bill

If I take out the WHERE, then how will I be able to select the desired client to make a change in their WageRate record?

BEGIN TRY

BEGIN TRANSACTION

UPDATE tbl_Clients_ClientWageRates

SET

AverageWage = coalesce(@AverageWage,...

Scott, thanks. With your help, I got it to work.

Bill

BEGIN

UPDATE tbl_EmployeeWageRates

SET

AverageWage = coalesce(@AverageWage, AverageWage),

FringeWage = coalesce(@FringeWage, FringeWage),

SpecialWage = coalesce(@SpecialWage, SpecialWage),

GuaranteedWage = coalesce(@GuaranteedWage, GuaranteedWage),

FutureUseField1 = coalesce(@FutureUseField1, FutureUseField1),

WageChangeDate = coalesce(@WageChangeDate, WageChangeDate)

WHERE

Employee_PK_ID =

(

Select...

That's the kind of direction I was hoping for. Thanks everyone.

Bill

K,

Thanks for the input. Being a rookie at this, I must pat myself on the back. I saw that I needed the ()'s while working on the other part.

Thanks,

Bill

Adam, I think we... excuse me...you, got it! I made a few very minor changes for my understanding and readability, but you got the logic. Thanks for your patience...