----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Sushil744 Message 2 in Discussion Possible solution to ur problem is to have a primary key in the table in case you dont have. As same Code can be there in mulitiple rows, it can't be Primary key for the table. Another way is to make a primary key from a comibination of 2 or more columns. ------------------------------------------------------------------------------------------------------------------------------------ HI ALL, I have to update a row in the table where there might be possible for duplication. For eg. There might be a code C123H which might be dupliated. But for each of these dupliation i need to update the other field with the new value. Say G,S,H Table after the opeation should look like Code Region C123H G C123H H C123H S At present my T_SQL inserts G in all the three row. Please can any one suggest how can my result table shown above can be achieved. Thanks in Advance, Vidhya _________________________________________________________________ "Post ads for free - to sell, rent or even buy.www.yello.in" http://ss1.richmedia.in/recurl.asp?pid=186 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
