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 |
|
ronin2307
Posting Yak Master
126 Posts |
 Posted - 2007-02-05 : 17:51:01
|
I am trying to populate a table with values from another tableinsert into TABLE_Avalues (select VALUE from DB1.dbo.TABLE_B order by VALUE) however this doesn't work. Is there an easy way to do something like this? Thanx |
|
|
ronin2307
Posting Yak Master
126 Posts |
Posted - 2007-02-05 : 17:53:03
|
| never mind. I figured it out.thanx |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-05 : 17:53:37
|
| insert into TABLE_A(columnA, columnB)select columnA, columnBfrom DB1.dbo.TABLE_B...Tara Kizer |
|
|
|
|
|
|
insert values