Arrow those variables!

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

DECLARE @ table(a varchar(80))

INSERT @ values
('sheriffOfNottingham'),('kingRichard'),('maidMarian'),
('bow'),('arrows'),('princeJohn'),('sherwoodForest')

SELECT a FROM(SELECT*,row_number()over(order by len(a))r
FROM @)x order by(r%2-.5)*r

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results