SQL Vendor

SET
@CreatureEntry = 60001,
@ItemStartEntry = 61000,
@MaxCount = 0,
@ExtendedCostID = 0,

INSERT INTO npc_vendor (entry, item, maxcount, ExtendedCost)
VALUES (@CreatureEntry, @ItemStartEntry, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+1, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+2, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+3, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+4, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+5, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+6, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+7, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+8, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+9, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+10, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+11, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+12, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+13, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+14, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+15, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+16, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+17, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+18, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+19, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+20, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+21, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+22, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+23, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+24, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+25, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+26, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+27, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+28, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+29, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+30, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+31, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+32, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+33, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+34, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+35, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+36, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+37, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+38, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+39, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+40, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+41, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+42, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+43, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+44, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+45, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+46, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+47, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+48, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+49, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+50, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+51, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+52, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+53, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+54, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+55, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+56, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+57, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+58, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+59, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+60, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+61, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+62, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+63, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+64, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+65, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+66, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+67, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+68, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+69, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+70, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+71, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+72, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+73, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+74, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+75, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+76, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+77, @MaxCount, @ExtendedCostID),
VALUES (@CreatureEntry, @ItemStartEntry+78, @MaxCount, @ExtendedCostID);