In my table there are 10 columns used for storing "items" (game server). When an user picks the item up, it should loop through columns 0-9 (with names "I0".."I9") and returns once the column in current row is empty. I cannot figure out how to do it on the SQL server side.
I can only think of IF EXISTS for each column but that is not really good.. Glad for any help! Thanks