Ok, I have been trying to figureout something for a long time and by
that I mean a couple of days.....


What I want to do is take the data from two colums and add them
together into one column.

All three columns have the same properties. nvarchar(19) and allowing
nulls

I want to do this conditionally. So that if there is data in on column
then it will take the information from the other and set it to the
final column and visa versa.


Here is what I have:


UPDATE [TestImportDB].[dbo].[Customers] SET [Acct_No]=[ACCT2] WHERE
[CC2]=null
UPDATE [TestImportDB].[dbo].[Customers] SET [Acct_No]=[CC2] WHERE
[ACCT2]=null


When I try doing this nothing happens no data moves... PLEASE HELP
ME!!!!


Thanks,

c

Clustered Index Not Working
Select distinct problems
SELECT Question: Get each date when I have start und end date
Learning SQL
Query help