Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Feb 27, 2012 11:28 AM|LINK
UPDATE tblDignosis_Test1 SET RnlSelTbSodium='115.0', RnlSelTbPotessium='3.4', RnlSelTbChloride='80.0', RnlSctTbValue='1.0', RnlSelTbSodium='117.0',
RnlSelTbSodium='120.0' WHERE ID = (SELECT ISNULL(MAX(ID),0) FROM tblDignosis_Test1)
Msg 264, Level 16, State 1, Line 1
The column name 'RnlSelTbSodium' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates
columns of a view, then the column name 'RnlSelTbSodium' may appear twice in the view definition.
Remove duplicate coloumns in Update Statement.....
Now i getting this error, so can any give me solution or method which check if string contains or exixst(RnlSelTbSodium) like that so can compare and check it out or better solution.