Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
suman.reddy39
Starting Member
34 Posts |
 Posted - 2008-10-06 : 01:20:10
|
| hi good morning,i got a table xxx in which i have already inserted some address in add column of a customer like contact add for some and billing add for some and shipping add for some. now what i need is i want to update or insert the add column so that each customer sholud have all the 3 add's. please help me in this regards.thanks in advance..Don't go the way Life takes you, Take the Life the way you gosubbi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 01:40:59
|
| [code]update xxxset contactadd=coalesce(contactadd,value1),billingadd=coalesce(billingadd,value2),shippingadd=coalesce(shippingadd,value3)[/code]where value1,value2,value3,... are supplied values |
 |
|
|
|
|
|
need to insert 2 more values