User Profile

m00nbeast · Jul 21 '07, 10:35 PM

Yay, I accomplished my goal with help from someone:

Code:

UPDATE beginning_balances SET fname = rtrim(ltrim(fname))

and then got the balance update finished with this:

Code:

UPDATE tblemp
SET tblEmp.balance = b.balance
FROM tblemp INNER JOIN 
	(SELECT beginning_balances.fname, beginning_balances.lname, beginning_balances.balance FROM beginning_balances) AS b
ON tblEmp.fname = b.fname AND

...

m00nbeast · Jul 21 '07, 09:43 PM

UGH! I just confirmed that all the fnames in beginning_balan ces have leading spaces in them! What's the quickest way to get rid of them? Change it in Excel somehow and then reimport? Create a new table and write to it while stripping out the leading spaces.... erm... somehow.

m00nbeast · Jul 21 '07, 09:40 PM

I apologize. I double checked and they are all nvarchar. I tried to change the OP to reflect this but the edit button is missing.

Heres what I found out. I tried to even just get records to come back:

Code:

SELECT t.fname, t.lname, t.balance, b.fname, b.lname, b.balance
FROM tblemp t
INNER JOIN beginning_balances b
ON t.fname = b.fname AND t.lname = b.lname

but it returned nothing so I dug...

m00nbeast · Jul 21 '07, 09:31 PM

Actually every balance in tblemp is at zero so it is unnecessary. I should have left that out. sorry....

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Updating one table from another