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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-08 : 07:56:57
|
| Mr.X writes "Hi I want to insert values from one table to another.. the table contains numeric values, with some zeros also. i want to insert only the values which are non-zero into another tablePlease solve my problem" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-06-08 : 07:59:01
|
| insert into table1select col1, col2, col3, etc from table 2where col1 > 0and col2 > 0and col3 > 0 |
 |
|
|
|
|
|
Inserting into one table from another