I’m am trying to create a StoredProc that will, if a value is below a limit it will insert one value or if the value is above a limit then it will insert another value. Sort of like this in C programming:

Code:
            if (ValueOriginal >= 3)
            {
                if (ValueOriginal <= 10)
                    ValueToInsert = ValueOriginal;
                else
...