MySQL Forums
Forum List  »  Italian

problema storedprocedure
Posted by: ogsbox :-)
Date: September 11, 2007 04:23PM

ciao a tutti,

ho un problema con una query...

devo creare una storedprocedure con case statement al suo interno (fino a qui tutto ok) ma che in base alla scelta nel case mi deve raggruppare i valori in modo differente.

esempio:

---------------------------------------------
SELECT SUM(O.chf),SUM(O.euro)

FROM Operazione O

WHERE

CASE _val
WHEN 1 THEN O.date =_date GROUP BY xxx; <--
WHEN 2 THEN MONTH(O.date)=MONTH(_date) GROUP BY yyy; <--
WHEN 3 THEN YEAR(O.date)=YEAR(_date) GROUP BY zzz; <--
END
---------------------------------------------

dovrei fare qualcosa di simile... ma cosi non funziona.

grazie

Options: ReplyQuote


Subject
Views
Written By
Posted
problema storedprocedure
4294
September 11, 2007 04:23PM
2889
September 12, 2007 08:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.