The (Easy) Road to Code

0

Please login or register to vote for this query.

(click on this box to dismiss)

ExpressionEngine® Answers

Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS

DECLARE @n INT=6,@ INT=-1

SELECT space(iif(@=1,y,y-@n)*@)+z+' '+iif(y%2=1,z,' ')+' '+z
FROM(SELECT
top(@n)row_number()over(order by 1/0)y,substring('\|/',@+2,1)z
FROM sys.messages)x ORDER BY y DESC

Enter Parameters

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