Skip to Content
0
Former Member
Mar 06, 2009 at 02:35 PM

Query pain - need help

19 Views

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