HI Experts,
I want to insert multiple records in a single SQL statement in a MII query template
I tried using
INSERT INTO TABLE (ID, Value)
VALUES (1, 'First'), (2, 'Second'), (3, 'Third')
But its not working out for me
Writing multiple insert statement is also an option but i want to write single insert statement and values separated by comma
Could any one kindly tell me how to insert multiple records in a single line with values separted by a comma
Thanks
Praveen