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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-11-18 : 15:39:55
|
| Pb description: what s an efficient way to get a subset of a datatable based on a query put in another tableHi,Let s say I have a datatable tbl1. What if I want all the rows that have the column myCol start with a letter 'D' for example. I want the result put in a new table called tbl2Are there several ways to achieve this, what s a good practice pls?Thanks a lot |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-18 : 16:00:35
|
look at INSERT INTO ... SELECT in bol.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
 |
|
|
|
|
|
I need subset of tbl1 put in tbl2