yes is  sql server 2000 !! Amazing stuff !!

Thanks a lot !

this block i will put it in the cursor loop .. if i am correct...!

declare @nm as varchar(50),@nm2 varchar(50), @cnt1 int,@cnt2 int
--select @nm='T_30767_AP10MinData9'

select TABLE_NAME into #pina 
from information_schema.tables 
where Table_Type = 'BASE TABLE' and table_name like '%AP10MinData9%'


declare curs1 cursor FORWARD_ONLY for...

USE [Reporting]
GO
/****** Object: StoredProcedure [dbo].[scans_eiserxomena]  Script Date: 07/09/2018 12:45:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[scans_eiserxomena] @path nvarchar(4000)

as