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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2003-08-13 : 22:06:07
|
| is possible to create table if the fields get from records on the other table??oh |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-13 : 22:18:14
|
| Yes:SELECT EmployeeID, FirstName, LastName INTO SmallEmployees FROM Northwind..Employees |
 |
|
|
u2p_inst
Yak Posting Veteran
78 Posts |
Posted - 2003-08-14 : 01:40:39
|
| no like that ..but like thisTableANameOfObjects======namebirthdateAddress...is possible to create query and the result isTableB likename birthdate Address==== ========= =======-the row data in tableA ==> fields in tableBoh |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-08-14 : 02:08:58
|
| If you can't be bothered giving correct information don't be surprised when the answer is wrong. You have just wasted Rob's time now.Do a search on the front page of the site for "Crosstab"Damian |
|
|
|
u2p_inst
Yak Posting Veteran
78 Posts |
Posted - 2003-08-14 : 03:46:26
|
| thanks Damian for your answer that solve my problemoh |
|
|
|
|
|
|
create table from table