- Code: Select all
string sql = @"INSERT INTO SY_WebhookMessage(RecID, SY_WebhookSubscription_RecID, Body, ItemNo, Status, LastSavedDateTime, AddedDateTime, Retries)
SELECT NewID(), SY_WebhookSubscription.RecID, @Body,
COALESCE(QueueTable.MaximumItemNo, 0) + ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),
0, SYSUTCDATETIME(), SYSUTCDATETIME(), 0
FROM SY_WebhookSubscription
CROSS JOIN (SELECT MAX(ItemNo) AS MaximumItemNo FROM SY_WebhookMessage) QueueTable
WHERE EventName = @EventName
ORDER BY SY_WebhookSubscription.ItemNo";