insert into reportmeterdatadictionary
( variabletype, SocketIndex, variablename, variableunits)
select 'real', max(SocketIndex),'Name', 'Unites' from Sockets;
( variabletype, SocketIndex, variablename, variableunits)
select 'real', max(SocketIndex),'Name', 'Unites' from Sockets;
insert into reportmeterdatadictionary
( variabletype, SocketIndex, variablename, variableunits)
select 'real', max(SocketIndex),'Name', 'Unites' from Sockets;
insert into ABC
(SocketIndex, variablename)
select max(SocketIndex),'Unites' from Sockets;