siddhartha mulpuru (ju******@yahoo.com) writes:
Do i have to create a new table inserting each record manually from
the existing table? is there any other way to do this
No, you could use an UPDATE statement, working from Ryan's sample.
Generally, when you post a question asking for a query, it is good
advice to post:
o CREATE TABLE statement for your table
o INSERT statements with sample data.
o The desired result.
This makes it easy for anyone to answers to cut and paste into Query
Analyzer to give you a tested solution. You did not post any of this,
and Ryan still took the task to post a tested solution, but he did it
in his way, so you could see the technique.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp