1 minSSMS - Stored procedure (Save code for re-use)If your query had to be run multiple times, the best way is to save a stored procedure. Saving a procedure may also allow other users...
2 minExcel XLOOKUP - Alternative to VLOOKUP (Maybe)XLOOKUP is a function which looks for a match from another table which will return a single result or range by row. This is a very...
1 minExcel HLOOKUP - Find items by rowIf VLOOKUP can find items vertically. Then HLOOKUP can assist with finding things horizontally. I would normally use this function when...