/*
INSERT INTO [meridian].[dbo].[incoming_data](
        TypeCall, NomRec, Cust, Org, Term, DayDate, DayTime, CallLong, Serv, AccesCod, TrunkCod, Dials, CallID)
select  TypeCall, NomRec, Cust, Org, Term, DayDate, DayTime, CallLong, Serv, AccesCod, TrunkCod, Dials, CallID
from  [tarif]...[01_07_04]

*/





INSERT INTO [meridian].[dbo].[imported_tables](
TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS)

EXEC sp_tables_ex  @table_server = 'tarif' --into imported_tables


delete [meridian].[dbo].[imported_tables]
where  TABLE_NAME  like 'MSys%'


DECLARE @tablename varchar( 50 )
declare @sql varchar( 3000 )


DECLARE it_cursor CURSOR FOR
SELECT  TABLE_NAME FROM [meridian].[dbo].[imported_tables] WHERE complete =  0 

OPEN it_cursor

-- Perform the first fetch.
FETCH NEXT FROM it_cursor into @tablename

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS =  0 
BEGIN
   
   PRINT 'Table: ' + @tablename
	set @Sql = 'INSERT INTO [meridian].[dbo].[incoming_data](
        TypeCall, NomRec, Cust, Org, Term, DayDate, DayTime, CallLong, Serv, AccesCod, TrunkCod, Dials, CallID)
select  TypeCall, NomRec, Cust, Org, Term, DayDate, DayTime, CallLong, Serv, AccesCod, TrunkCod, Dials, CallID
from  [tarif]...[' + @tablename + ']'	


	exec ( @sql )
	update [imported_tables] set complete =  1  where table_name = @tablename


   -- This is executed as long as the previous fetch succeeds.
   FETCH NEXT FROM it_cursor into @tablename
END

CLOSE it_cursor
DEALLOCATE it_cursor