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 |
|
ramu143
Yak Posting Veteran
64 Posts |
 Posted - 2008-09-29 : 00:52:20
|
| CREATE TABLE [destasrreport] [FileDate] [sitecode] [call_domain], [did] [pfxcode] [choice] [grade_route] [duration] [connect_flag] [cause47] [disc_party1] [disc_party2] [WastageTime] [WastageCallCnt] [PDD] [trff_pfx] [Destination] ) ON [PRIMARY]GOCREATE TABLE [destasrreport] ( [FileDate] [did] NULL , [pfxcode] [choice] de_route] [duration] [connect_flag] [PDD] [trff_pfx] [Destination] ) ON [PRIMARY]GOCREATE TABLE [destasrreport] ( [FileDate] [switchcode] [call_domain] [did] NULL , [pfxcode] [choice] [duration] [connect_flag] [cause47] [disc_party1] [disc_party2] [WastageTime] [WastageCallCnt] [pdd] [trff_pfx] [Destination] ) ON [PRIMARY]GOthese are three tables used in three different procedure i need to crearte single table and the three procedure data should be inseted into a single tablehow to create asingle table with these columns.please help me this is very neccesarry |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-29 : 01:17:31
|
| just use single create table statement and include all the columns inside it |
 |
|
|
|
|
|
to create a table