All pastes #152511 Raw Edit

Mine

public text v1 · immutable
#152511 ·published 2006-08-28 21:10 UTC
rendered paste body
DECLARE @sortDir varchar(5)
	SELECT @sortDir = 
		CASE 
			WHEN @SortDirection = "Ascending" THEN ' ASC'
			WHEN @SortDirection = "Descending" THEN ' DESC'
		END


Msg 207, Level 16, State 1, Procedure sp2_GetAllCategories, Line 17
Invalid column name 'Ascending'.
Msg 207, Level 16, State 1, Procedure sp2_GetAllCategories, Line 18
Invalid column name 'Descending'.