Hi @ll,
i got this query, but it does not work. Any idea ?
DECLARE @xyz nvarchar(1) SELECT @xyz = (SELECT T0.TreeType FROM OITM T0 WHERE T0.ItemCode = [%1]) SELECT CASE @xyz <> 'S' THEN '1' ELSE '2' END
Thanks Steffen
