Får inte denna kod att fungera. Om @subcID är 0 då skall den ta ut där prod_cate_id är lika med @categoryID annars där prod_subc_id är lika med @categoryID.
Felmeddelande: "Incorrect syntax near '='"(röd färg)
SELECT DISTINCT left(prod_title,1) as letters
FROM products
WHERE
CASE @subcID
[red]WHEN 0 THEN prod_cate_id = @categoryID[/red]
ELSE prod_subc_id = @categoryID
ORDER BY letters
SELECT DISTINCT left(prod_title,1) as letters
FROM products
WHERE @categoryID =
CASE @subcID
WHEN 0 THEN prod_cate_id
else prod_subc_id end
ORDER BY letters
jag skulle nog skriva
if @subcID = 0
SELECT DISTINCT left(prod_title,1) as letters
FROM products
WHERE prod_cate_id = @categoryID
ORDER BY letters
else
SELECT DISTINCT left(prod_title,1) as letters
FROM products
WHERE prod_subc_id = @categoryID
ORDER BY letters
