Thanks :)

"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarkaavtenta.si > wrote in
message news:erONT$FQDHA.1908TK2MSFTNGP11.phx.gbl...
> Create the destination table. Create a cursor and loop through the list of
> the tables. For each table execute INSERT INTO destination_table SELECT
> col_list FROMsource_table. Instead of cursor, you can help yourself with a
> undoented procedure sp_MSforeachtable. Check the syntax at
> [url]http://www.bstsoftware.com/tsug/Nov99/sp_MSforeachtable.html[/url].
>
> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: [url]http://www.sqlserverfaq.com[/url]
> Please reply only to the newsgroups.
> PASS - the definitive, global community
> for SQL Server professionals - [url]http://www.sqlpass.org[/url]
>
> "Tom S." <curryspicehotmail.com> wrote in message
> news:eb23NtEQDHA.1908TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I have more than 200 tables with the same table structure whose need to
> > merge into a single table. However, I don't want to merge them one by
one
> > manually.
> >
> > Does anyone know how to do this by sql ? Any help would be greatly
> > appreciated.
> >
> > Thanks
> >
> > Tom S.
> >
> >
>
>