First order of business... why are you using varchar(23) to store dates?   Given that you are using ANSI PADDING turned on that only affects those columns, that just isn't making...

I don't see any reason to break this up at all.   One table is sufficient to hold a given address.  Just the extra query complexity of having a separate table...

One thing you are doing that might cause trouble is the CONVERT(varchar(7), [pkKPIID]) portion, which will fail on any value of the pkKPIID column that is greater than 9,999,999 or less...

Wondering if it might be useful to use sp_msforeachdb, which is an undocumented stored procedure that can do that kind of thing.  You use ? in your query wherever you...

I'm pretty sure what you want is a view:
CREATE VIEW NBCVadodra
AS
SELECT Tstamp, Inverter_id, AC_Power, total_energy_generated_till
FROM [dbo].[IN-023C-I1]
UNION ALL
SELECT Tstamp, Inverter_id, AC_Power,total_energy_generated_till
FROM [dbo].[IN-023C-I2]
UNION ALL

Replication is the Microsoft way to do this.   Not that there aren't other ways, but you might need to somehow ensure that the session established by the trigger actually ends...

Sorry, but I doubt anyone has any idea what you are looking for.   Could be a language barrier problem, but a fairly clear English explanation is needed here.   The words...