Sorta a college alumni - SQL newbie here, Wondering a way to updating 3 items with repeating numbers (triplets), without having to type/change in the ItemIds manually (see example) like 4018, 4019, 4020...etc...etc..Then changing to 4021, 4022, 4023.
set AltName = SectionSize+'PLN'
where ItemID = 4015
set AltName = SectionSize+'SRTD'
where ItemID = 4016
set AltName = SectionSize+'SMTH'
where ItemID = 4017
In that note; Is it easy to add in doubles (ie. odd, even variables) where I can change all the odd numbers or even numbers.. for if I have doubles to change.