1st query:
SELECT TOP(1) @tmpOnlineCat = ac.AlertCatID FROM alert.AlertCategory ac WHERE ac.FkAlertID = 2 AND ac.FkAlertTypeID = 3
2nd query
SELECT TOP(1) @tmpOfflineCat = ac.AlertCatID FROM alert.AlertCategory ac WHERE ac.FkAlertID = 3 AND ac.FkAlertTypeID = 3
3rd query
INSERT INTO item.ItemOnlineOfflineAlertCategory VALUES ( @tmpPkItemID, @tmpOfflineCat, @tmpOnlineCat )