SQL Looping in BIRT

Greetings all,

I am looking to do a sql loop in BIRT. I'm using BIRT 2.3.0 on win7OS and Oracle 10g DB.

I am passing in a start date and end date and want to execute the sql by month inbetween the date range. For example:
StDate = '01-JAN-2009'
EnDate = '31-JUL-2009'

Normally within SQL you would use LOOP with EXIT WHEN varDate > enDate
but BIRT doesn't allow these statements.

thanks in advance for your help!

Mike W

Find more posts tagged with

Comments

bappoo

Use a stored procedure in the database and then call that from the data set.

wirzbicki

Didn't think of that but of course will try it out. Some times we don't have ability to create store procedures on the db so I was looking for alternatives.

Mike W.

Hans_vd

I'm not sure what you mean by "to execute the sql by month inbetween the date range", but do know that you don't need an SQL with LOOP in it. As a matter of fact LOOP is not even a keyword in standard SQL.

So if you can clarify what you mean by "to execute the sql by month inbetween the date range", I'll probably be able to show you how to do it in SQL