HI,
I have a table
Create table test(a int identity(1,1), b int)
insert into test(b) values(12)
insert into test(b) values(30)
insert into test(b) values(65)
insert into test(b) values(78)
insert into test(b) values(36)

o/p
a b
1 12
2 30
3 65
4 78
5 36

i need to copy the table into another table with creating the new
table
we had a option
select * into newtable from oldtable
here the data in the oldtable will e copied to new table without
creating new table
but i need to copy the data as shown below with out creating new
table
o/p
a b
11 12
12 30
13 65
14 78
15 36

Thanks,
Satish

If I understand your question, you want to insert the data from table
test into an already existing table.

INSERT existingtable
SELECT a, b
FROM test

Roy Harvey
Beacon Falls, CT

On Mon, 20 Aug 2007 09:21:30 -0000, satish
<satishkumar.gourabathina (AT) gmail (DOT) com> wrote:

Roy Harvey (roy_harvey (AT) snet (DOT) net) writes:
I guess it should be:

INSERT existingtable
SELECT 10 + a, b
FROM test

since Salish wanted to change the values.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Mon, 20 Aug 2007 21:54:50 +0000 (UTC), Erland Sommarskog
<esquel (AT) sommarskog (DOT) se> wrote:

Thanks for catching that, Erland.

Roy