SQL
From: <kskasi_at_hotmail.com>
Date: 2000/06/16
Message-ID: <3949EB1F.4D6048C0_at_hotmail.com>#1/1
.
.
.
200012 $1
Date: 2000/06/16
Message-ID: <3949EB1F.4D6048C0_at_hotmail.com>#1/1
[Quoted] Hello everyone
[Quoted] 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 [Quoted] a given date range
cheers...kasi Received on Fri Jun 16 2000 - 00:00:00 CEST