From: Martin Gainty
Date: November 23 2007 3:43pm
Subject: RE: Problem with a Procedure
List-Archive: http://lists.mysql.com/mysql/210171
Message-Id: <BAY108-W260789723F0E99E589D0C4AE7A0@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_9c1ac6a5-4d7f-469e-bee2-1a50c88be186_"

--_9c1ac6a5-4d7f-469e-bee2-1a50c88be186_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Tomas-I would effect a quick iterative check on the table(s) to see if they=
 are empty e.g.
=20
SELECT count(trans2.nettovikt) from trans2;
(If recordcount>0) then
SELECT SUM(trans2.nettovikt)  FROM trans2 INNER JOIN artikel on trans2.arti=
kel=3Dartikel.artikel
(If recordcount>0) then
SELECT SUM(trans2.nettovikt) INTO ut_summa FROM trans2 INNER JOIN artikel o=
n trans2.artikel=3Dartikel.artikel WHERE trans2.transtid between 'datum1' a=
nd 'datum2'
=20
(If recordcount > 0) then
 SELECT SUM(trans2.nettovikt) INTO ut_summa  FROM trans2 INNER JOIN artikel=
 on trans2.artikel=3Dartikel.artikel  WHERE trans2.transtid between 'datum1=
' and 'datum2'
  and artikel.reservinteger=3D'skatt'
=20
(If recordcount > 0) then
 SELECT SUM(trans2.nettovikt) INTO ut_summa  FROM trans2 INNER JOIN artikel=
 on trans2.artikel=3Dartikel.artikel  WHERE trans2.transtid between 'datum1=
' and 'datum2'
  and artikel.reservinteger=3D'skatt'  group by artikel.volympris;Does this=
 help???
Martin Gainty______________________________________________Disclaimer and c=
onfidentiality noteEverything in this e-mail and any attachments relates to=
 the official business of Sender. This transmission is of a confidential na=
ture and Sender does not endorse distribution to any party other than inten=
ded recipient. Sender does not necessarily endorse content contained within=
 this transmission.> Date: Fri, 23 Nov 2007 11:10:47 +0100> From: tomas.hyl=
ander@stripped> To: mysql@stripped> Subject: Problem with a Procedu=
re> > Hi!> Hope you can help me with this one.> Im trying to learn this wit=
h stored procedures and optimize my databases.> Can someone point what wron=
g with this?> -------------------------------------------------------------=
-------------------------------------------------------------------------> =
> DELIMITER $$> > DROP PROCEDURE IF EXISTS `vagsql`.`sok` $$> CREATE DEFINE=
R=3D`root`@`localhost` PROCEDURE `sok`(skatt int,> datum1 DATE,> datum2 DAT=
E,> OUT ut_summa decimal(8,2))> BEGIN> > SELECT SUM(trans2.nettovikt) INTO =
ut_summa> FROM trans2 INNER JOIN artikel on trans2.artikel=3Dartikel.artike=
l> WHERE trans2.transtid between 'datum1' and 'datum2'> and artikel.reservi=
nteger=3D'skatt'> group by artikel.volympris;> > END $$> > DELIMITER ;> > -=
---------------------------------------------------------------------------=
--------------------------------------------> > call sok('01','2007-01-01 0=
0: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 i=
n query brower everything looks ok.> SELECT SUM(trans2.nettovikt) as summa =
FROM trans2 INNER JOIN artikel on> trans2.artikel=3Dartikel.artikel WHERE t=
rans2.transtid between '2007-07-01> 00:00:00' and '2007-07-02 23:59:59' and=
 artikel.reservinteger=3D'01' group by> artikel.volympris;> > Im running my=
sql 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=3DTXT_TAGLM_Wave2_sharelife_1120=
07=

--_9c1ac6a5-4d7f-469e-bee2-1a50c88be186_--