SQL
From: <kskasi_at_hotmail.com>
Date: 2000/06/16
Message-ID: <3949EB1F.4D6048C0_at_hotmail.com>#1/1
Date: 2000/06/16
Message-ID: <3949EB1F.4D6048C0_at_hotmail.com>#1/1
Hello everyone
I've got a table named projects which has got customer_budget in it.
This customer_budget is for 12 months of the year. Basically I need to
spread that out throughout the year. So if the customer budget is $12
the output should look something like this
Period Budget
200001 $1
200002 $1
200003 $1
.
.
.
200012 $1
Period is to_char(date,'YYYYMM). Is it possible to get that output for
a given date range
cheers...kasi
Received on Fri Jun 16 2000 - 00:00:00 CEST