DECLARE @DatabaseName NVARCHAR(128);
DECLARE @SQL NVARCHAR(MAX);
DECLARE @ManualDate VARCHAR(10) = '2026-03-28';

-- Cursor to iterate through all databases
DECLARE db_cursor CURSOR FOR
SELECT DatabaseName + '' + CONVERT(VARCHAR(2), YEAR(FromDate) % 100) + '-' + CONVERT(VARCHAR(2), YEAR(ToDate) % 100) as name FROM AyMaster WHERE        (DeleteFlag = 0)

OPEN db_cursor;
FETCH NEXT FROM db_cursor INTO @DatabaseName;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- Build the dynamic SQL
    SET @SQL = 'USE ' + QUOTENAME(@DatabaseName) + ';

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N''[dbo].[DB_DataModiFolderClientSide]'') AND type in (N''U''))
	DROP TABLE [dbo].[DB_DataModiFolderClientSide];

CREATE TABLE [dbo].[DB_DataModiFolderClientSide](
	[TID] [bigint] NOT NULL,
	[TDateTime] [datetime] NULL,
	[FolderName] [nvarchar](150) NULL,
	[SubFolderName] [nvarchar](150) NULL,
	[FileName] [nvarchar](150) NULL,
	[FileType] [nvarchar](150) NULL,
	[FolderAction] [nvarchar](max) NULL,
	[Result] [nvarchar](50) NULL,
 CONSTRAINT [PK_DB_DataModiFolderClientSide_1] PRIMARY KEY CLUSTERED 
(
	[TID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY];

INSERT [dbo].[DB_DataModiFolderClientSide] ([TID], [TDateTime], [FolderName], [SubFolderName], [FileName], [FileType], [FolderAction], [Result]) VALUES (0,CONVERT(DATE, ''' + @ManualDate + ''', 23), N''-'', N''-'', N''1'', N''SQLScript'', N''Execute'', N''-'') ; 

				Select TDateTime from DB_DataModiFolderClientSide;

				';  -- Replace with your actual SQL query
    -- Execute the dynamic SQL
    EXEC sp_executesql @SQL;

    FETCH NEXT FROM db_cursor INTO @DatabaseName;
END

-- Clean up the cursor
CLOSE db_cursor;
DEALLOCATE db_cursor;
