I want to develop a TSQL
query. First I need to determine if all the numbers in one of the fields are in
numerical order and also find the missing holes in the number sequence. Secondly
I need to sort by another field and by a particular criteria. The words
that I need to sort-by would be different makes and models of cars that would
not necessary be at a give position in the cell: the criteria may be found in
different position within one of the cells yet may be in different cell within
the same rows. So the end result would need to show all the numbers in
sequential order. Any place there is a brake in the sequential number or
there is a hole or a missing number a blank would be inserted or some kind of
indicator. Also all the numbers sequences would need to be grouped by different vehicles
makes and modules. They may be randomly located with in three different
columns but would be in the same rows.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!