Tomas-I would effect a quick iterative check on the table(s) to see if they are
empty e.g.
SELECT count(trans2.nettovikt) from trans2;
(If recordcount>0) then
SELECT SUM(trans2.nettovikt) FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel
(If recordcount>0) then
SELECT SUM(trans2.nettovikt) INTO ut_summa FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel WHERE trans2.transtid between 'datum1' and
'datum2'
(If recordcount > 0) then
SELECT SUM(trans2.nettovikt) INTO ut_summa FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel WHERE trans2.transtid between 'datum1' and
'datum2'
and artikel.reservinteger='skatt'
(If recordcount > 0) then
SELECT SUM(trans2.nettovikt) INTO ut_summa FROM trans2 INNER JOIN artikel on
trans2.artikel=artikel.artikel WHERE trans2.transtid between 'datum1' and
'datum2'
and artikel.reservinteger='skatt' group by artikel.volympris;Does this
help???
Martin Gainty______________________________________________Disclaimer and
confidentiality noteEverything in this e-mail and any attachments relates to
the official business of Sender. This transmission is of a confidential nature
and Sender does not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained within this
transmission.> Date: Fri, 23 Nov 2007 11:10:47 +0100> From: [EMAIL PROTECTED]>
To: mysql@lists.mysql.com> Subject: Problem with a Procedure> > Hi!> Hope you
can help me with this one.> Im trying to learn this with stored procedures and
optimize my databases.> Can someone point what wrong with this?>
-------------------------------------------------------------------------------------------------------------------------------------->
> DELIMITER $$> > DROP PROCEDURE IF EXISTS `vagsql`.`sok` $$> CREATE [EMAIL
PROTECTED] PROCEDURE `sok`(skatt int,> datum1 DATE,> datum2 DATE,> OUT ut_summa
decimal(8,2))> BEGIN> > SELECT SUM(trans2.nettovikt) INTO ut_summa> FROM trans2
INNER JOIN artikel on trans2.artikel=artikel.artikel> WHERE trans2.transtid
between 'datum1' and 'datum2'> and artikel.reservinteger='skatt'> group by
artikel.volympris;> > END $$> > DELIMITER ;> >
------------------------------------------------------------------------------------------------------------------------>
> call sok('01','2007-01-01 00:00:00', '2007-01-10 23:59:59', @out);> select
@out;> > All I get is that "No data - zero rows fetched, selected or
processed"> > When running this in query brower everything looks ok.> SELECT
SUM(trans2.nettovikt) as summa FROM trans2 INNER JOIN artikel on>
trans2.artikel=artikel.artikel WHERE trans2.transtid between '2007-07-01>
00:00:00' and '2007-07-02 23:59:59' and artikel.reservinteger='01' group by>
artikel.volympris;> > Im running mysql 5.1.11.> > Thanks in advance!> /Tomas
_________________________________________________________________
Share life as it happens with the new Windows Live.Download today it's FREE!
http://www.windowslive.com/share.html?ocid=TXT_TAGLM_Wave2_sharelife_112007
