var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CASE statement question
Suppose I want to do the following:
SET @num = -1 /* initial value */
SELECT col1, col2,
WHEN -1 THEN ( [assign a value to @num], [return that value] )
END AS 'num'
In English, I only want the @num variable to be calculated once but appear in every column of the SELECT result, since table T1 has many rows.
Greatly appreciate any help... thanks in advance!!
it looks like SQL Server ???? Is it true ?
(Alligator Company GmbH)
Yes... it is SQL Server...