INSERT INTO
	CustomActionAdapter(NodeID, AdapterName, AssemblyName, TypeName, ConnectionString, Enabled)
SELECT
	(SELECT ID FROM Node) AS NodeID,
	'VACTION' + CONVERT(VARCHAR, IntValue) AS AdapterName,
	'TestingAdapters.dll' AS AssemblyName,
	'TestingAdapters.VirtualActionAdapter' AS TypeName,
	'MeasurementReportingInterval=2147483647; InputMeasurementKeys={ FILTER ActiveMeasurements WHERE SignalType IS NOT NULL }' AS ConnectionString,
    1 AS Enabled
FROM
	ufn_GenerateIntegers(100)
ORDER BY
	IntValue