blossompark
asked on
updating column data in sql server 2005
Hi,
I have a table with two columns.
I want to update cells in columnB to contain the same data as columnA when columnB has “Not Available” as its contents
any help appreciated....thanks
BEFORE
columnA columnB
abc12345 Not Available
abc45672 abc45672
AFTER
columnA columnB
abc12345 abc12345
abc45672 abc45672
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER